Difference between revisions of "PostgreSQL: CREATE ROLE"
Jump to navigation
Jump to search
(25 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | * <code>[[CREATE | + | * <code>[[CREATE]] ROLE</code> adds a new [[role]] to a [[PostgreSQL]] database [[cluster]]. A role can be considered a [[user]], or [[group]]. |
==Overview== | ==Overview== | ||
− | * https://www.postgresql.org/docs/ | + | * https://www.postgresql.org/docs/14/sql-createrole.html |
− | + | CREATE ROLE name [ [ WITH ] option [ ... ] ] | |
+ | |||
+ | where option can be: | ||
+ | |||
+ | [[SUPERUSER]] | NOSUPERUSER | ||
+ | | [[CREATEDB]] | NOCREATEDB | ||
+ | | CREATEROLE | NOCREATEROLE | ||
+ | | CREATEUSER | NOCREATEUSER | ||
+ | | INHERIT | NOINHERIT | ||
+ | | LOGIN | [[NOLOGIN]] | ||
+ | | REPLICATION | NOREPLICATION | ||
+ | | CONNECTION LIMIT connlimit | ||
+ | | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | ||
+ | | VALID UNTIL 'timestamp' | ||
+ | | IN ROLE role_name [, ...] | ||
+ | | IN GROUP role_name [, ...] | ||
+ | | ROLE role_name [, ...] | ||
+ | | ADMIN role_name [, ...] | ||
+ | | USER role_name [, ...] | ||
+ | | SYSID uid | ||
− | + | === Examples === | |
+ | * <code>[[CREATE ROLE]] my_username WITH LOGIN PASSWORD 'jw8s130F4' VALID UNTIL '2022-01-01';</code> | ||
+ | * <code>CREATE ROLE my_username WITH CREATEDB [[CREATEROLE]]; </code> | ||
+ | * <code>CREATE ROLE my_username [[NOLOGIN]];</code> | ||
− | + | == Related == | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | == Related | ||
* <code>[[ALTER USER]]</code> | * <code>[[ALTER USER]]</code> | ||
− | * <code>[[CREATE USER]]</code> | + | * <code>[[PostgreSQL: CREATE USER]]</code> |
+ | * [[PostgreSQL: Database roles]] | ||
+ | * <code>[[GRANT]] your_username_origin TO your_new_username_with_same_privileges;</code> | ||
+ | * <code>[[useradd]]</code> | ||
+ | * [[List users]]: <code>[[\du]]</code> | ||
+ | * [[ERROR: role "your role" does not exist]] | ||
+ | * [[EOF]] | ||
+ | * [[PostgreSQL users]] | ||
− | ==See also== | + | == See also == |
− | * {{ | + | * {{Role}} |
− | * {{ | + | * {{CREATE}} |
[[Category: PosgreSQL]] | [[Category: PosgreSQL]] | ||
[[Category: SQL]] | [[Category: SQL]] |
Latest revision as of 10:22, 11 July 2023
CREATE ROLE
adds a new role to a PostgreSQL database cluster. A role can be considered a user, or group.
Contents
Overview[edit]
CREATE ROLE name [ [ WITH ] option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN | REPLICATION | NOREPLICATION | CONNECTION LIMIT connlimit | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | VALID UNTIL 'timestamp' | IN ROLE role_name [, ...] | IN GROUP role_name [, ...] | ROLE role_name [, ...] | ADMIN role_name [, ...] | USER role_name [, ...] | SYSID uid
Examples[edit]
CREATE ROLE my_username WITH LOGIN PASSWORD 'jw8s130F4' VALID UNTIL '2022-01-01';
CREATE ROLE my_username WITH CREATEDB CREATEROLE;
CREATE ROLE my_username NOLOGIN;
Related[edit]
ALTER USER
PostgreSQL: CREATE USER
- PostgreSQL: Database roles
GRANT your_username_origin TO your_new_username_with_same_privileges;
useradd
- List users:
\du
- ERROR: role "your role" does not exist
- EOF
- PostgreSQL users
See also[edit]
Advertising: