Grant user read-write permission to a single database

• PJ_SQL

  SSCertifiable

  Points: 6703

  More actions

  November 15, 2024 at 8:06 pm

  #4482392

  Hello!

  How do I grant a user to read-write to a single database and deny viewing rest of the databases in SSMS.

  I have tried:

  DENY VIEW ANY DATABASE to <login>

  but then have make the user as db-owner to view a particular database.

  How can I give read-write permission to a single database to a user and deny viewing rest of the databases without making it owner of the database?

   

  Thanks in advance.