How do you set a SQL database to read only?

How do you make a database user read only?

USE <db name>; Create a Login for your user. CREATE LOGIN <user name> WITH PASSWORD = “<password>”; Create new user to connect to datapine.

Can we make database read only?

Databases can be set to READ ONLY mode and back using T-SQL and SSMS.

How do I know if my SQL database is read only?

SELECT name, is_read_only FROM sys. databases WHERE name = 'MyDBNAme' GO --returns 1 in is_read_only when database is set to read-only mode.

How do I create a read only access in SQL Server?

In the Login-New dialog box, in the Select a page pane, click User Mapping. In the right pane, under Users mapped to this login, make sure that you have selected the database to read. Under Database role membership for the database, click db_datareader. This role gives the user read-only data access to the database.