revoke all access for public



If I am required to revoke all privileges from the public role (Government
standards), what affect would that have on the fixed database roles? I'm
finding out that db_securityadmin, for example, now doesn't have privileges
to execute sp_addrole unless I explicitly grant execute permissions to the
user in the db_securityadmin role. But, that defeats the purpose of putting
them into the role somewhat - aside from the fact that I want to group
certain security administrators.


.