August 17, 2005 at 3:08 pm
Maybe it's a newbie question, but when I grant access to a new user for a particular database I would expect that they could only see that one database from Enterprise Manager. But no, the user can see the list of all 100 or so databases on the SQL Server. Why?
August 17, 2005 at 4:43 pm
A use can see all the databases listed under Databases in EM even he has not access to them. But he can not see any contents of a database, such as Tables,Views etc, unless he is a user of the database
August 17, 2005 at 11:56 pm
As lugang says, by EM lists all databases in the server instance, not just the ones that the user has access to. It uses the stored procedure sp_MSdbuseraccess to do this. Take a look at this KB article that provides a modified version of that sp which only lists databases that the user has access to.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply