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

0 vote154 views1 answer
Allow external access to mysql
SQL
4 votes144 views1 answer
Sql any
SQL
0 vote154 views1 answer
Mysql set variable to today's date
SQL
1 vote149 views2 answers
Sql groub by count
SQL
0 vote159 views1 answer
MySql get primary keys of table
SQL
17 votes193 views4 answers
Mysql remove ubuntu
SQL
0 vote181 views2 answers
How to type a blank discord messgae
SQL
-1 vote162 views1 answer
Mysql change database charset and collation
SQL
1 vote177 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote530 views1 answer
How to connect .sql data set to powerbi
SQL