March 12, 2008 at 9:57 pm
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
March 18, 2008 at 9:14 pm
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