Post reply

Permissions for Public Role

  • March 12, 2008 at 9:57 pm

    #71460

    Hi all,

    I have been searching all the forums but unable to find a answer to this problem.

    I am trying to see what are the permissions for the user role Public. I tried sp_helprotect but it shows object permissions like "Execute", "Select". What I am looking for are statement permissions like "Create View", etc.

    Although sp_srvrolepermission displays the kind of permissions I am looking for, public role is nowhere to be found. Can anyone help?

    If public role already has certain default permissions, why can't I see they displayed upon sp_srvrolepermission?

  • March 13, 2008 at 12:02 am

    #788894

    Shouldn't that make it obvious that the Public role has no rights beyond SELECT?

    Regards,

    goodguy

    Experience is a bad teacher whose exams precede its lessons

  • March 18, 2008 at 9:14 pm

    #791261

    I understand that Public only has "Execute" and "Select".

    But these are object permissions.

    I am looking for a way to display statement permissions which are the following:

    Create Table

    Create View

    Create Procedure

    Create Default

    Create Function

    Create Rule

    Backup Database

    Backup Log

    I read that Public by default does not have any of these permissions. But I remembered assigning some of these to Public.

    I used query: exec sp_srvrolepermission. It returns the kind of permissions I want but Public is nowhere to be found. Does it means that Public did not get the assigned permissions?

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

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