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 votes342 views3 answers
How to describe a table in sqlite3
SQL
2 votes397 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote299 views2 answers
Postgresql could not start server mac
SQL
15 votes609 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote344 views1 answer
Mysql where in keep order
SQL
0 vote398 views1 answer
Get substract count sql
SQL
2 votes328 views1 answer
Check isolation level in mysql
SQL
4 votes343 views2 answers
Linq join
SQL
0 vote382 views1 answer
How to convert external table to managed table in hive
SQL
0 vote295 views1 answer
Java spring boot connect to sql server
SQL