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 vote138 views1 answer
Autocommit mysql
SQL
1 vote123 views1 answer
Mysql check table exists
SQL
2 votes125 views1 answer
Mysql last 7 days including today
SQL
2 votes177 views1 answer
Oracle trace session
SQL
0 vote95 views1 answer
Sql table to store status
SQL
0 vote118 views1 answer
SQL server select to get sum of hours
SQL
2 votes118 views1 answer
Oracle number to percentage
SQL
1 vote120 views4 answers
Get week day from date in sql
SQL
0 vote115 views1 answer
Update having mysql
SQL
1 vote115 views1 answer
Trigger in postgresql to change incoming entry
SQL