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

1 vote246 views1 answer
Mysql size int
SQL
3 votes229 views1 answer
MySQL DELETE JOIN
SQL
0 vote246 views1 answer
Helptext in sql
SQL
0 vote248 views1 answer
Mysql last 6 months
SQL
0 vote242 views1 answer
Varchar2 length in oracle
SQL
0 vote231 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
4 votes216 views2 answers
What is table in sql
SQL
0 vote220 views10 answers
John the ripper mysql
SQL
0 vote221 views1 answer
Create domain sql
SQL
1 vote263 views1 answer
Sql server delete top 1000
SQL