Security Access to Select tables and views

  • Good day everyone,

    Iam trying to limit the access for SQL 2005; I created a role designed to select tables and views only; i added table and view securables, and chose it one by one; what do i need to choose under the list of explicit permissions. I tried using just the select and still not working; they still dont have access on the specific table; need your help. what other permissions do i need to grant?

    thanks in advance,

  • Hi,

    You might be all right with setting up db_datareader role for accessing tables and views. In your situation make sure the users have connection permissions to the server.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply