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

11 votes218 views2 answers
Import sql file laravel cmd
SQL
-1 vote173 views1 answer
How to use update trigger in sql
SQL
1 vote308 views1 answer
Mysql breakline on string
SQL
3 votes186 views2 answers
Oracle apex charging debug
SQL
0 vote187 views1 answer
Mysql update privileges
SQL
1 vote158 views1 answer
Oracle compile schema
SQL
0 vote193 views1 answer
Drop-toys-table
SQL
0 vote179 views1 answer
Postgres call view
SQL
11 votes210 views3 answers
Sql line numbers
SQL
0 vote212 views1 answer
Excel vba import data to sql server
SQL