SQLServer-Deny/Revoke permission on sysdatabases

[lazymouse1984]

Hi,

I want to revoke/deny select on master..sysdatabases from a specific user.

I ran DENY select ON master.dbo.sysdatabases to User1
REVOKE select ON master.dbo.sysdatabases from User1

But it doesn't help. User1 still can run select * from master.dbo.sysdatabases.
Can anyone help me on this issue?

Thanks

 

[Qik3Coder]

Um, what are you actually trying to do?

If the user doesn't have access to a specific database, then they can't see it. This is built in.

Lodlaiden

You've got questions and source code. We want both!