Post reply

I want to check the permissions given to a user not login on particular schema

  • April 27, 2011 at 6:58 am

    #1316525

    Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

    Thanks OPC,

    Is there any way to check the permissions applying on a User?

    From day one this is my query..

    Thanks

  • April 27, 2011 at 7:08 am

    #1316533

    sp_helprotect is deprecated but in my opinion is easier to use than its recommended replacements sys.database_permissions and fn_builtin_permissions. This page is for sp_helprotect, note the "Important" message at the top of the article.

    http://msdn.microsoft.com/en-us/library/ms190310.aspx

    sp_helprotect will not htell the whole story though. If the user owns an objects or is part of a Server or Database Role it can have implicit rights to some entities.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 16 through 16 (of 16 total)

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