Question: Question 1 4 ( 1 point ) 4 ) Listen | A PostgreSQL database administrator sets up the following:CREATE ROLE readonly group NOLOGIN;GRANT SELECT ON

Question 14(1 point)4) Listen |A PostgreSQL database administrator sets up the following:CREATE ROLE readonly group NOLOGIN;GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly group;GRANT readonly-group TO user, user2;What is the primary advantage of this configuration?It simplifies management by centralizing read-only access within a group role and then granting this role to individual users. It allows all users to modify data within the public schema. It provides comprehensive write access to users through the group role. It establishes a direct permission link between tables in the public schema and individual users.

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!