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

4 votes168 views5 answers
Get last query in codeigniter 4
SQL
0 vote174 views1 answer
Plpgsql create function
SQL
1 vote96 views1 answer
Flask-sqlalchemy filter_by contains
SQL
2 votes128 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote144 views1 answer
MySQL - Enabling the Event Scheduler
SQL
4 votes225 views4 answers
Update select mysql
SQL
-1 vote142 views3 answers
How to restart mysql in linux
SQL
2 votes151 views1 answer
How to get non distinct values in sql
SQL
0 vote133 views1 answer
Composit key in sql
SQL
0 vote140 views1 answer
Sql tabelle erstellen
SQL