Which fixed database role provides full control over a database?
Options
-
A.
db_owner
-
B.
db_datareader
-
C.
db_accessadmin
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
A.
db_owner
Detailed Explanation
- db_owner: Members can perform all configuration and maintenance activities in the database.
- They have broad administrative permissions within that database.
- It is different from the server-level sysadmin role.
OOps! You are currently offline.