June 1, 2005 at 8:13 am
How do you make sure a specific user can only see the database he has access to in Enterprise Manager
By default the specific user can see a list of databases on the server, even the ones he can't access.
/SteenT
June 1, 2005 at 9:23 am
I am not sure that you can keep users from seeing database they don't have access to. It would be nice if you could. I just make sure the user has no rights to databases they shouldn't.
June 1, 2005 at 12:58 pm
You can't restrict this. Everybody who connects can issue a
SELECT * FROM master..sysdatabases
The reglementing factor here however is the access to the databases.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 2, 2005 at 3:15 am
The good news is that this can in fact be done and was covered here before.
Please see:
http://support.microsoft.com/default.aspx/kb/889696
Despite the topic of the article it shows how to achieve what you want, although "SELECT * FROM master..sysdatabases" will still work.
The SQL General
June 2, 2005 at 3:24 am
Thanks for the link. I need to keep that in mind.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply