Post reply

Deny Permission for an Object

  • February 4, 2015 at 8:31 am

    #294498

    Is any body know how can we deny an Object select Permission which have Sysadmin role.

    Please Advise me on this.

  • February 4, 2015 at 9:02 am

    #1775363

    it is not possible to deny a sysadmin access to anything.

    permissions checks are shortcutted if you are sysadmin, and all deny/revoke permissions you might create are ignored.

    the only solution is to take away sysadmin priviledges.

    only then can you restrict a users permissions.

    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!

  • February 4, 2015 at 9:10 pm

    #1775557

    kumar.satheesh.k (2/4/2015)

    Is any body know how can we deny an Object select Permission which have Sysadmin role.

    Please Advise me on this.

    As the previous person said, SysAdmin has total control. What you need to do is create an account with only the minimum, required permissions and have the person or process use that account. Can you tell us more details about the environment? Who/what is involved? What are you ultimately trying to accomplish?

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

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