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 |
|
lazymouse
Starting Member
1 Post |
 Posted - 2011-10-04 : 14:24:34
|
| Hi,I want to revoke/deny select on master..sysdatabases from a specific user. I ran DENY select ON master.dbo.sysdatabases to User1REVOKE select ON master.dbo.sysdatabases from User1But it doesn't help. User1 still can run select * from master.dbo.sysdatabases.Can anyone help me on this issue?Thanks |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2011-10-05 : 05:18:00
|
| What SQL role groups is User1 a member of? |
 |
|
|
|
|
|
Deny/Revoke permission on sysdatabases