Multiple choice technology databases

Which of the following fixed database roles can add or remove user IDs?

  1. db_accessadmin

  2. db_securityadmin

  3. db_setupadmin

  4. db_sysadmin
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The db_accessadmin fixed database role has permission to add and remove user IDs from the database. db_securityadmin manages role memberships and permissions, db_setupadmin manages configuration, and there is no db_sysadmin role (sysadmin is a server role, not a database role).

Keep practicing — related questions