Difference between revisions of "PostgreSQL: Database roles"
Jump to navigation
Jump to search
| (15 intermediate revisions by 3 users not shown) | |||
| Line 3: | Line 3: | ||
Create role: | Create role: | ||
* <code>[[create role]]</code> | * <code>[[create role]]</code> | ||
| + | * <code>[[create user]]</code> | ||
| + | |||
| + | * <code>[[PostgreSQL: CREATE USER|CREATE USER]] name WITH Role XXX</code> | ||
List [[users]] and roles: | List [[users]] and roles: | ||
* <code>[[\du]]</code> | * <code>[[\du]]</code> | ||
| + | * <code>[[\du+]]</code> | ||
* <code>[[SELECT rolname FROM pg_roles;]]</code> | * <code>[[SELECT rolname FROM pg_roles;]]</code> | ||
| + | * <code>[[SELECT * FROM pg_roles]];</code> | ||
| + | |||
| + | Assign roles: | ||
| + | * <code>[[GRANT "your-defined role" TO "your username";]]</code> | ||
== Related terms == | == Related terms == | ||
| − | + | * <code>[[CREATE ROLE]]</code>, <code>[[create user]]</code> | |
| − | * <code>[[ | ||
| − | |||
* [[Schema]] | * [[Schema]] | ||
* <code>[[GRANT]]</code> privileges to [[roles]] | * <code>[[GRANT]]</code> privileges to [[roles]] | ||
| − | * [[Superuser]] | + | * <code>[[Superuser]]</code> |
* <code>[[rds_superuser]]</code> role in [[AWS RDS]] | * <code>[[rds_superuser]]</code> role in [[AWS RDS]] | ||
| + | * [[Ansible roles]] | ||
| + | * [[ALTER USER myuser WITH SUPERUSER;]] | ||
| + | * [[DROP ROLE]] | ||
| + | * [[community.postgresql.postgresql_privs]] | ||
| + | * <code>[[\list+]]</code> | ||
== See also == | == See also == | ||
* {{Role}} | * {{Role}} | ||
| − | * {{ | + | * {{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:
