Resrtict Enterprise Manager 1

[qsac]

how can i restrict the access of my shared SQL server, so when a client logs in via EM, they can only see there DBs?

Thanks,
Q

 

[jgoodman00]

Not sure about visibility, but by removing the [guest] user from each database you can stop them from viewing the objects within.



James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com

 

[Catadmin]

In addition to disabling guest, check out the Security -> Logins tab in EM. There, if you right click a group or a user, you can make sure they don't have Permit access to your DBs or any server roles that grants them the ability to grant themselves access to the DB.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[mrdenny]

Instead of removing the guest account, you can remove the public roles ability to read the sysobjects table. This will also restrict the users from looking at the objects within another users database.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)