Grant Select permission on a specific SQL table:

We can provide a user to a specific table access with read only or other type like insert and update.

See below:

Step 1: Create any sql user

Step 2: Create A Database Role

CREATE ROLE <RoleName>

Step 3: Give Role Permission to the table

GRANT INSERT, SELECT , UPDATE ON <TABLENAME> TO <RoleName>

Step 4: Apply Role to the User.

sp_addrolemember <RoleName> , <UserName>

==================================================================

 

 

Advertisements