Sql grant select only

#You can use Create User to create a user
CREATE LOGIN sam
    WITH PASSWORD = '340$Uuxwp7Mcxo7Khy';
USE AdventureWorks;
CREATE USER sam FOR LOGIN sam;
GO 

#and to Grant (Read-only access) you can use the following
GRANT SELECT TO sam

#Credit: John Sansom

Source: stackoverflow.com

Similar codes

34 votes289 views6 answers
Sql change data type
SQL
0 vote300 views1 answer
What alter does in db
SQL
0 vote287 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote290 views1 answer
Select all tables linked server sql
SQL
0 vote276 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote312 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote343 views3 answers
Characters found after end of sql statement
SQL
0 vote304 views1 answer
Top frequency in sql server
SQL
7 votes304 views2 answers
Postgres concat
SQL
1 vote305 views3 answers
Mysql parse int
SQL