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 votes166 views1 answer
Oracle rollback
SQL
10 votes175 views1 answer
Oracle object dependencies
SQL
0 vote191 views4 answers
What is unique key in sql
SQL
0 vote136 views1 answer
Import sql file in mysql linux
SQL
0 vote164 views1 answer
Mysql date minus 1 day
SQL
0 vote178 views2 answers
How to count codition
SQL
7 votes187 views3 answers
SQL create a new table
SQL
1 vote187 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote191 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
11 votes209 views1 answer
Oracle view source
SQL