April 8, 2016

How to create read only users in SQL Server 2012


Database Version: SQL Server 2012
Step 1.
Connect to your database server.
Expand Security > Logins > New login.

Step 2.
Put the login name and  select sql server authentication  and provide password.
On this window you may/ may not select the option enfornce password policy.

Step 3.
From User Mapping option select the database you want to give access.
Tick the boxes for role membership next to public and db_datareader.
Confirm by clicking OK.

Done. The read only user is created!

No comments:

Post a Comment

Oracle ADRCI Utility Explained with Practical Examples on Windows

 Recently, while troubleshooting an Oracle issue on a Windows server, I realized how many DBAs still depend only on alert logs and trace fil...