Post reply

SQL login security

  • February 11, 2008 at 1:32 am

    #378438

    Hi,

    our customers can see all databases on our SQL 2005 server, they don't have access to them but they're visible.

    How can we make shure that our customers only can see their own databases?

    We're using SQL logins on MS SQL 2005 Server.

  • February 11, 2008 at 1:07 pm

    #777053

    May I suggest: DENY VIEW ANY DATABASE TO [login]. When VIEW ANY DATABASE is revoked, the user can only see master, tempdb, any database he owns, and the user’s current database context.

    - Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford

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

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