Difference between revisions of "PostgreSQL: Database roles"
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 25: | Line 25: | ||
* [[ALTER USER myuser WITH SUPERUSER;]] | * [[ALTER USER myuser WITH SUPERUSER;]] | ||
* [[DROP ROLE]] | * [[DROP ROLE]] | ||
| + | * [[community.postgresql.postgresql_privs]] | ||
| + | * <code>[[\list+]]</code> | ||
== See also == | == See also == | ||
* {{Role}} | * {{Role}} | ||
| − | * {{PostgreSQL}} | + | * {{GRANT}} |
| + | * {{PostgreSQL Privileges}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Latest revision as of 12:07, 16 December 2022
Create role:
CREATE USER name WITH Role XXX
List users and roles:
Assign roles:
Related terms[edit]
CREATE ROLE,create user- Schema
GRANTprivileges to rolesSuperuserrds_superuserrole in AWS RDS- Ansible roles
- ALTER USER myuser WITH SUPERUSER;
- DROP ROLE
- community.postgresql.postgresql_privs
\list+
See also[edit]
- PostgreSQL: Database roles,
CREATE USER,CREATE ROLE,\du, \du+,create user, Alter user 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- PostgreSQL Privileges, GRANT,
\list+, \du+
Advertising:
