Grant read permission to user

Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 90
Suppose you need a database user(TestUser) who should have only the READ permission on specific table data(TestTable), but not any other (update, execute SPs, backup permission and so on).

For the above scenario, we need to create a user and grant them the SELECT permission

grant SELECT on dbo.TestTable to TestUser;

Comments or Responses

Login to post response