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 vote180 views1 answer
Mysql server does not start mac
SQL
7 votes198 views2 answers
Create index mysql cli
SQL
0 vote219 views1 answer
Select new table sql
SQL
2 votes196 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote194 views1 answer
How to list function in psql
SQL
1 vote245 views1 answer
How not to sort by average rating
SQL
0 vote186 views1 answer
Sql create table with datetime automatically
SQL
0 vote195 views1 answer
Geopoint from json mysql function
SQL
0 vote211 views1 answer
Get initial in sql
SQL
-1 vote217 views1 answer
How to Activate the database
SQL