Difference between revisions of "PostgreSQL: Database roles"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 26: | Line 26: | ||
* [[DROP ROLE]] | * [[DROP ROLE]] | ||
* [[community.postgresql.postgresql_privs]] | * [[community.postgresql.postgresql_privs]] | ||
| + | * <code>[[\list+]]</code> | ||
== See also == | == See also == | ||
* {{Role}} | * {{Role}} | ||
| + | * {{GRANT}} | ||
* {{PostgreSQL Privileges}} | * {{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:
