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 sales_data TO sales_rep;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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!