revoke all access for public
- From: "A McGuire" <allen.mcguire@xxxxxxxxxxxxxxxxx>
- Date: Wed, 12 Jul 2006 14:05:22 -0500
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.
.
- Prev by Date: Re: Newbie needs help
- Next by Date: Windows non-Admin user and file permissions
- Previous by thread: Changing SA Password in SQL 2005
- Next by thread: Windows non-Admin user and file permissions
- Index(es):