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?