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?