Sunday, 23 June 2024

How to grant permissions to user account in SQL server ?

In this video, I have explained how to grant permissions to user account in SQL Server.

Steps:-

1) Login into SQL server.

2) Expand databases, select database and expand security.

3) Expand users, all the users of database will appear.

4) Select particular user, right click on it and go to properties. New window will         appear.

5) Select Securable page.

6) Click on search button and add objects of all types

7) Select object type whose access you want to give to user. (for e.g. table or           stored procedures) and click on ok.

8) Select permissions for that object and click on ok.

    Above steps are explained in detail in below video


No comments:

Post a Comment