easy5 pts · first answer countsdatabase-securitypostgresql

Read-only access for analysts

Analysts need to query all tables in the sales schema but must not change data. What is the best PostgreSQL approach?

A.Create a role with USAGE on the schema and SELECT on its tables (plus default privileges for new tables)B.Share the application user password with the analystsC.Make the analysts owners of the sales schemaD.Give them superuser and ask them to be careful

← Why a write-ahead log exists What pg_hba.conf controls →