Scenario: A DBA needs to grant access to a specific table in DB2 to a new user while ensuring the least privilege principle. How should they approach this task?
- Grant SELECT permission on the specific table to the new user.
- Grant ALL privileges on the specific table to the new user.
- Grant INSERT, UPDATE, and DELETE privileges on the specific table to the new user.
- Grant EXECUTE privilege on the specific table to the new user.
The correct option is to grant SELECT permission on the specific table to the new user. This adheres to the least privilege principle, ensuring that the user only has the necessary access required for their tasks without granting unnecessary privileges. Granting ALL privileges or excessive permissions increases the risk of unintended data manipulation or security breaches.
Loading...
Related Quiz
- Scenario: A security audit reveals unauthorized access attempts in a DB2 database. What steps should the DBA take to investigate and mitigate potential security risks?
- Which SQL command is used to delete records from a table?
- How does the Lock Manager contribute to ensuring data integrity in DB2's architecture?
- ________ mechanisms in DB2 help to detect and resolve data integrity violations.
- Which normal form requires all determinants to be candidate keys?