Post reply

Filter database list in SSMS

  • July 28, 2009 at 12:47 am

    #207376

    Hi,

    I have a server with 15 databases, and I want to create a SQL login where the user will have access to only 1 of those databases.

    I can set up those permission with no problem, but I want the list of databases to be filtered.

    When he opens management studio, I want only the 1 DB he has access to, to be listed - not all the other 14 DBs.

    Is that possible?

  • July 28, 2009 at 1:35 pm

    #1031288

    triple post.

    please continue here .


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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