The user IDs can be added or removed using which of the following fixed roles?

Asked In: BPSC TRE 3.0

Options

  • A. db_sysadmin
  • B. db_accessadmin
  • C. db_securityadmin
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. db_accessadmin

Detailed Explanation

  • db_accessadmin: Allows members to add or remove access to the database for Windows logins, Windows groups and SQL Server logins.
  • db_securityadmin: Manages database permissions and role membership.
  • db_sysadmin: Has full administrative control at the server level.