Question: In a PostgreSQL database, a database administrator issues the following commands:CREATE ROLE sales _ rep;GRANT SELECT ON sales _ data TO sales _ rep;What best
In a PostgreSQL database, a database administrator issues the following commands:CREATE ROLE sales rep;GRANT SELECT ON salesdata TO salesrep;What best practice does this command sequence illustrate? Encouraging the use of shared roles among multiple users to simplify accesscontrol.Applying the principle of least privilege by granting only the necessary permissions for a sales representative to perform their job. Allowing sales representatives to modify sales data directly in the database. Granting unnecessary privileges to roles to ensure comprehensive access.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
