Which fixed database role can manage database permissions and role membership?
Options
-
A.
db_datareader
-
B.
db_securityadmin
-
C.
db_backupoperator
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
B.
db_securityadmin
Detailed Explanation
- db_securityadmin: Can manage permissions and role membership in a database.
- Members can grant, deny and revoke permissions, subject to security restrictions.
- It is a fixed database role in SQL Server.
OOps! You are currently offline.