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

36 votes226 views6 answers
Rename table sql
SQL
7 votes214 views1 answer
Postgres base size
SQL
0 vote186 views1 answer
Mariadb list tables
SQL
3 votes480 views1 answer
Postgresql cast
SQL
5 votes197 views1 answer
Mysql select greater than yesterday
SQL
0 vote218 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote232 views1 answer
Firebase sql
SQL
-1 vote212 views1 answer
Count occurrences sql
SQL
2 votes216 views1 answer
Wait delay in sql server
SQL
0 vote301 views1 answer
Mysql show schema
SQL