Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Permissions for Public Role Expand / Collapse
Author
Message
Posted Wednesday, March 12, 2008 9:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 28, 2008 7:14 PM
Points: 8, Visits: 22
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?
Post #468490
Posted Thursday, March 13, 2008 12:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 1, 2012 3:30 PM
Points: 292, Visits: 1,028
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

Post #468512
Posted Tuesday, March 18, 2008 9:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 28, 2008 7:14 PM
Points: 8, Visits: 22
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?
Post #471348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse