Post reply

How to pervent domain users from viewing all databases ?

  • January 24, 2008 at 4:30 pm

    #178558

    Any domain user with datareader and datawriter permissions can register the sql server using sql managment studio and see all database , is there a way to stop that ?

    Thanks

  • January 24, 2008 at 5:15 pm

    #771550

    zahranym (1/24/2008)

    Any domain user with datareader and datawriter permissions can register the sql server using sql managment studio and see all database , is there a way to stop that ?

    Thanks

    Don't grant those permissions to people that don't need them, and setup your applications so that people don't need them.

  • January 25, 2008 at 6:08 am

    #771697

    You have domain users granted login to the box? With what rights? If so, remove it and set up appropriate windows groups and set their permissions to just what the people need.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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