Wednesday, March 21, 2012

Enterprise Manager User Log-in DB Visability

I have created new login in my Enterprise Manager. The login is not part of any roles and only allowed access to 1 database (of 200). However, they can see all the databases in Enterprise Manager.

They can't do anything with them, but I don't even want them to see them.

Have I set something up wrong?Hi ,

I posted earlier the same questune , i think that its not possible for users wont be bale to see the dbs , but i couldnt prevent also access to the master db objects that is realy bad thing .|||There must be something that can be done! How would an ISP that wants to host SQL Server for people deal with it?

No comments:

Post a Comment