Difference between revisions of "PostgreSQL read only user"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
== Related == | == Related == | ||
* [[GRANT CONNECT]] | * [[GRANT CONNECT]] | ||
| + | * [[PostgreSQL predefined roles]] | ||
== See also == | == See also == | ||
Revision as of 10:10, 23 September 2024
CREATE ROLE my_readonly WITH LOGIN PASSWORD '123456';GRANT CONNECT on database YourDB to my_readonly;GRANT pg_read_all_data, pg_monitor TO my_readonly;
Related
See also
- PostgreSQL users, predefined roles:
pg_read_all_data, pg_monitor,create role,.pgpass, PostgreSQL read only user CREATE ROLEGRANT,\ddp,GRANT USAGE,GRANT ALL PRIVILEGES,GRANT SELECT, View GRANTs on Redshift,has_table_privilege,has_schema_privilege,HAS_DATABASE_PRIVILEGE,SCHEMA, Privileges,GRANT EXECUTE
Advertising:
