QuestionQ123

VerifiedData and Database Security

A database administrator needs to give a manager access to all employee data while allowing employees to access only their own information. Which of the following best enables this requirement?

Explanation

Row-based access control, commonly called row-level security, controls access to individual table rows according to the querying user, role, or execution context. It can allow a manager to view every employee record while filtering each employee’s access to only their own record.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!