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

6 votes300 views1 answer
How to count number of rows in sql
SQL
1 vote320 views1 answer
Postgresql create table with timestamp
SQL
0 vote324 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
1 vote325 views2 answers
Sql for date greater than
SQL
4 votes332 views1 answer
Postgresql list sequences
SQL
3 votes319 views2 answers
How to start mysql in terminal
SQL
1 vote317 views1 answer
Alter constraint postgres
SQL
10 votes279 views2 answers
Django mysql
SQL
0 vote324 views1 answer
Call function sql oracle with output put line
SQL
0 vote303 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL