Grant user read-write permission to a single database

  • 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.

     

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • you can't do that as far as I know - if you do that deny then db_owner is required - but having the list of db's on SSMS does NOT grant that user any rights to it unless you grant them at either server role/permission level or at db level - so I don't see it as an issue.

     

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

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