Enterprise Manager

[Mark Dostie]

Hi,
I would like to know if we can present users to access details database information about the databases on a server through Enterprise Manager.
If you create a SQL login and do NOT give it access to any database, if someone logons on your server with enterprise manager, even though he does not have access to any database, he will still see the list of all database on your servers plus tons of sensitive information like database owner.
Is is possible to limit enterprise manager to only view information about database that the user has access to?

Thanks
Mark

[Chakri]

Remove the 'Guest' user from each database and make sure that the 'public' role is not having any permissions. This way, though the user is able to see the list of databases, he can not see any objects in the database.


------------
Mark Dostie at 3/13/01 4:55:23 PM

Hi,
I would like to know if we can present users to access details database information about the databases on a server through Enterprise Manager.
If you create a SQL login and do NOT give it access to any database, if someone logons on your server with enterprise manager, even though he does not have access to any database, he will still see the list of all database on your servers plus tons of sensitive information like database owner.
Is is possible to limit enterprise manager to only view information about database that the user has access to?

Thanks
Mark

[Chakri]

Remove the 'Guest' user from each database and make sure that the 'public' role is not having any permissions. This way, though the user is able to see the list of databases, he can not see any objects in the database.


------------
Mark Dostie at 3/13/01 4:55:23 PM

Hi,
I would like to know if we can present users to access details database information about the databases on a server through Enterprise Manager.
If you create a SQL login and do NOT give it access to any database, if someone logons on your server with enterprise manager, even though he does not have access to any database, he will still see the list of all database on your servers plus tons of sensitive information like database owner.
Is is possible to limit enterprise manager to only view information about database that the user has access to?

Thanks
Mark