Post reply

security of a login

  • June 12, 2012 at 10:43 am

    #275749

    If I have a login (a single windows user) that is a dbowner of a database, but the login is also in a group that only has db reader permission to the same database.

    Which one will overwrite the other, the more permission or less permission?

    Thanks

  • June 12, 2012 at 10:45 am

    #1499922

    sqlfriends (6/12/2012)

    If I have a login (a single windows user) that is a dbowner of a database, but the login is also in a group that only has db reader permission to the same database.

    Which one will overwrite the other, the more permission or less permission?

    Thanks

    Based on the above, they will still have have dbowner privs.

  • June 13, 2012 at 1:38 am

    #1500183

    The most restrictive option only applies if you have a deny and a grant to the same permission

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

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