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 point 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 readonlygroup TO user, user;What is the primary advantage of this configuration?It simplifies management by centralizing readonly 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
