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

0 vote249 views1 answer
Mariadb set vertical output format
SQL
5 votes241 views2 answers
Create function postgresql
SQL
0 vote224 views1 answer
Tsql generate rows
SQL
0 vote243 views2 answers
What is rownum in oracle
SQL
0 vote258 views1 answer
Bigrock database connection string
SQL
1 vote232 views1 answer
SQL: merging multiple row data in string
SQL
0 vote230 views1 answer
Mysql not defined
SQL
4 votes233 views2 answers
Sql server date now
SQL
1 vote219 views1 answer
Oracle rolling back
SQL
10 votes228 views1 answer
Oracle dba_dependencies
SQL