locked
Securables - Deny Access to Specific Tables RRS feed

  • Question

  • Hello,

    I have a group contained in the Logins folder which I want to deny specific access to. These tables contain information that I do not want anyone in the group to access at any level. Under the Login Properties for this user, the "Search..." I'm unable to select the specific tables I want to deny access to. Any help in how to do this would be greatly appreciated.

    Greg


    Greg Whipkey

    • Moved by Olaf HelperMVP Thursday, April 10, 2014 7:01 AM Moved from "SQL Database Engine" to a more specific forum.
    Wednesday, April 9, 2014 9:52 PM

Answers

  • Greg,

    The crux of the issue is that Logins are at the server level and only access server level objects such as linked servers, server metadata, endpoints, etc. What you want to do is apply these DENYs to USERS which are at the database level. Users are linked to logins via SIDs (Security IDentifiers) under the covers.

    Go to the database in question and look at the users, one of them will correspond to that login, set the permissions against the USER.


    Sean Gallardy | Blog | Twitter

    Wednesday, April 9, 2014 10:30 PM

All replies