Which fixed database role allows members to insert, update and delete data in all user tables?
Options
-
A.
db_datareader
-
B.
db_datawriter
-
C.
db_accessadmin
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
B.
db_datawriter
Detailed Explanation
- db_datawriter: Allows members to insert, update and delete data in all user tables.
- It is used for data modification operations.
- It does not automatically grant permission to read all data.
OOps! You are currently offline.