Permissions for Public Role

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » Permissions for Public Role

Permissions for Public Role

Rate Topic

Display Mode

Topic Options

Author

Message

Rachie

Posted Wednesday, March 12, 2008 9:57 PM

Forum 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

goodguy

Posted Thursday, March 13, 2008 12:02 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, October 01, 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

Rachie

Posted Tuesday, March 18, 2008 9:13 PM

Forum 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 »

Permissions