October 19, 2005 at 8:01 am
What is the best way to secure a SQL Server that is being used by many people. I want to let them use Enterprise Manager but only let them see and interact with the Dbs they own. Is this possible?
October 20, 2005 at 7:42 am
Why not have them log into Enterprise Manager each time? You may need to create a standard SQL Server login for each person if you are only using Windows authentication. On the server right click the server name in EM and select "Edit SQL Server Registration Properties". Then check "always prompt for login name and password". No matter what login is in the default box, the user just needs to type in their login and password.
Linda
October 20, 2005 at 6:17 pm
Derek -
Unfortunately there's no way that I'm aware of to hide databases from authenticated SQL Server 2000 users - everyone with EM will see all of the databases, they cannot access the databases unless the proper permissions are in place but they can see them.
This has been corrected in SQL 2005 - many of the changes in 2005 are security/granularity related. The ability to "see" all of the databases on a server, even if the user does not have access is a good example of the improvements in SQL 2005 - users will only "see" databases to which they have been specifically granted access.
Joe
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply