Which SQL Server fixed database role provides read access to all user tables and views?
Options
-
A.
db_datareader
-
B.
db_datawriter
-
C.
db_owner
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
A.
db_datareader
Detailed Explanation
- db_datareader: Allows members to read data from all user tables and views.
- Members can execute SELECT operations on user objects.
- It does not automatically provide permission to modify records.
OOps! You are currently offline.