Post reply

Prevent visibility other dbs in EM

  • April 29, 2009 at 5:00 am

    #199967

    I've been asked to create some restricted SQL :Whistling: accounts which only have access to 1 db. Along side the usual :doze: list of "must be able to..." and "must not be able to..." is this one:

    Must only be able to see their db when viewing through Enterprise Manager. :ermm:

    While I can have EM say "DENIED" :crying: when the user clicks on another db, the fact remains that it's visible. Can you stop this?

  • April 29, 2009 at 5:36 am

    #985802

    Please test the script in UAT environement given in the link

    http://support.microsoft.com/kb/889696/en-us

    -:-)

    Cheer Satish 🙂

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

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