db_accessadmin vs. db_securityadmin

[jjonesal]

Could anyone give me a brief overview of how these are similar and different or point me to a good resource? In books online, I haven't found much info.

Thanks in advance,


J. Jones
jjones@cybrtyme.com

 

[aalmeida]

See the thing is this:
- A user is an object into the database or a person that has access to it and without permitions even though it exists it can not do anything other than what is allowed to the public group (most of the time nothing)
- Permitions they determine what you can and cannot do when you access a database

db_securityadmin is a administrator fuction to allow an user to add and revoke permition from a user id but not to creat the user ID's.
db_accessadmin is an administrator function to allow an account to creat user ID's but no to assign permitions AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[kim1]

Both are database role:

db_security: Have permission to add or remove user IDs.

db_accessadmin: Have permission to manage all permissions, object ownerships, roles and role memberships.

Kim