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

9 votes387 views3 answers
Sql delete where in
SQL
1 vote324 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote336 views1 answer
Java nosql sort
SQL
0 vote336 views1 answer
Mysql undo delete
SQL
0 vote376 views1 answer
New rails app with mysql
SQL
1 vote359 views1 answer
Sql server delete top 1000
SQL
1 vote354 views1 answer
Second last highest id in sql
SQL
0 vote339 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote368 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
3 votes309 views1 answer
Index using in query plsql
SQL