Difference between revisions of "PostgreSQL read only user"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | + | * [[CREATE ROLE]] my_username WITH LOGIN PASSWORD '123456' | |
Revision as of 16:15, 20 September 2024
- CREATE ROLE my_username WITH LOGIN PASSWORD '123456'
See also
- PostgreSQL users, predefined roles:
pg_read_all_data, pg_monitor
,create role
,.pgpass
, PostgreSQL read only user CREATE ROLE
GRANT
,\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: