---

Search posts under SQL Server:

---

Permissions for a specific user in SQL Server

How to specify permissions (Read/Write) for a specific user in the database?

To specify the permission for a specific user in the database, right click the user in the Security > Login folder and select Properties. Now from the left panel, select Securables and select appropriate permission from the Permissions list and check appropriate checkbox against the Permission type. Apart from that we can also select database role by clicking the User Mapping options from the left panel. Follow the same approach as in the previous point of creating new user.