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.
OOps! You are currently offline.