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

2 votes171 views1 answer
Drop table purge
SQL
3 votes167 views1 answer
Oracle function
SQL
0 vote177 views1 answer
Executescalar in sql server
SQL
0 vote207 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote193 views1 answer
Express api ith mysql data
SQL
0 vote168 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote173 views1 answer
Heidisql check how much space a row
SQL
0 vote191 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote204 views1 answer
Postgre query date
SQL
9 votes170 views2 answers
Sql limit order by
SQL