Difference between revisions of "PostgreSQL read only user"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
* <code>[[CREATE ROLE]] my_username WITH LOGIN PASSWORD '123456'</code> | * <code>[[CREATE ROLE]] my_username WITH LOGIN PASSWORD '123456'</code> | ||
| − | + | * <code>GRANT [[pg_read_all_data]], [[pg_monitor]] TO xxx;</code> | |
| − | * GRANT [[pg_read_all_data]], [[pg_monitor]] TO xxx; | ||
== See also == | == See also == | ||
Revision as of 16:16, 20 September 2024
CREATE ROLE my_username WITH LOGIN PASSWORD '123456'GRANT pg_read_all_data, pg_monitor TO xxx;
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:
