Post reply

Deny/Revoke permission on sysdatabases

  • October 4, 2011 at 10:39 am

    #258483

    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

  • October 4, 2011 at 10:47 am

    #1390246

    is the login the user is connected to a member of the sysadmins?

    is "User1" really a domain account like myDomain\User1 that might be inheriting BuiltIn\Administrators,?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 4, 2011 at 10:56 am

    #1390251

    Yes, the user is a member of the sysadmins. Because when I tried to remove the user from sysadmins. I cannot login with that user.

    The User1 doesnt inherit BuiltIn\Administrators, it's standard user.

    Lowell (10/4/2011)

    is the login the user is connected to a member of the sysadmins?

    is "User1" really a domain account like myDomain\User1 that might be inheriting BuiltIn\Administrators,?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply