How to check Permissions for Public role? RRS feed

  • Question

  • Hi,

    can someone help how to check the permissions for PUBLIC ROLE?

    Thanks for the help in advance,

    Gurumurthy Valmiki


    One Life..! Live it...!
    Thursday, December 16, 2010 1:08 PM


  • One way is:

    EXEC sp_helprotect @username = 'public'

    A more thorough answer if you are using 2005 or higher would use the newer catalog views, such as sys.database_permissions.

    select class_desc, object_name(major_id) as object_name,
         permission_name, state_desc
    from sys.database_permissions
    where grantee_principal_id = user_id('public')
      and class_desc <> 'DATABASE'
    order by class_desc, object_name


    Thursday, December 16, 2010 1:23 PM