Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simonw2003
Starting Member
11 Posts |
 Posted - 2007-07-11 : 10:40:48
|
| I have agents who use their own database on our platform. I give them full access to their own databases, but I dont want them to see each others or the main central databases.Is it possible via denying access to some SPs or tables to prevent an agent viewing things in enterprise manager, so they cant even see the names of the other databases.Query analyser is ok, as I know I deny access to things like sp_who2 etc and sysprocesses etc.thankssimon |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-11 : 11:39:11
|
| let each user have it's own login which is mapped to only one user in his database.let that user in the database have dbo rights._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
simonw2003
Starting Member
11 Posts |
Posted - 2007-07-12 : 03:59:22
|
| When following those steps, the user still has access to browse information via enterprise manger such as the list of database names. |
|
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-12 : 04:08:47
|
| but they cannot get data out of it.Need an SQLDB consultant?check www.veeningsengineering.nl |
|
|
|
|
|
|
block or limit use of entperprise manager