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

3 votes180 views3 answers
How to add month in update sql
SQL
1 vote262 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote159 views1 answer
Trim sql oracle
SQL
0 vote185 views1 answer
Qt qsql check if table exist
SQL
0 vote177 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
1 vote288 views1 answer
Aqua Data studio postgresql ssl
SQL
1 vote191 views1 answer
Where not in array sql
SQL
36 votes188 views6 answers
Rename table sql
SQL
0 vote206 views1 answer
Pgadmin save data greyed out
SQL
0 vote191 views1 answer
Python dictionary to sql update
SQL