Which SQL Server statement is used to add an existing database user to a fixed database role?
Options
-
A.
ALTER ROLE role_name ADD MEMBER user_name;
-
B.
DROP ROLE role_name user_name;
-
C.
CREATE USER role_name;
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
A.
ALTER ROLE role_name ADD MEMBER user_name;
Detailed Explanation
- ALTER ROLE: Modifies membership of a database role.
- Example: ALTER ROLE db_datareader ADD MEMBER student_user;
- This statement adds an existing database user to the specified role.
