Deny view on Database and select Permission

• niladri.primalink

  SSCommitted

  Points: 1751

  More actions

  March 19, 2014 at 5:47 am

  #291079

  Hi All,

  I have a problem. I create a new user who will have a read only permission on TestDB.

  I want to give only select permission on TestDB and also I don't want that the new user will not see any other database.

  DENY VIEW ANY DATABASE to user_readonly

  ALTER AUTHORIZATION ON DATABASE :: TestDB TO user_readonly

  but when I am using the above query then the new user is the owner of the testdb. i don't want that. I want that the user will have only select permission on the table.

  is there any way?

• Adam Angelini

  SSCrazy Eights

  Points: 8548

  More actions

  March 19, 2014 at 3:33 pm

  #1698536

  Why not just add them to the db_datareader role in the database?