Difference between revisions of "PostgreSQL: CREATE ROLE"
Jump to navigation
Jump to search
Tags: Mobile web edit, Mobile edit |
|||
| (53 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | CREATE [[ROLE]] | + | <code>[[CREATE]] ROLE</code> adds a new [[role]] to a [[PostgreSQL]] database [[cluster]]. A role can be considered a [[user]], or [[group]]. |
| + | ==Overview== | ||
| + | * 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]] '123456' [[VALID UNTIL]] '2022-01-01';</code> | ||
| + | * <code>CREATE ROLE my_username WITH CREATEDB [[CREATEROLE]]; </code> | ||
| + | * <code>CREATE ROLE my_username [[NOLOGIN]];</code> | ||
| + | == Related == | ||
| + | * <code>[[ALTER 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]] | ||
| + | * [[ERROR: permission denied to create role]] | ||
| + | == See also == | ||
| + | * {{create role}} | ||
| + | * {{Role}} | ||
| + | * {{CREATE}} | ||
| − | + | [[Category: PosgreSQL]] | |
| − | + | [[Category: SQL]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 16:27, 20 September 2024
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 '123456' VALID UNTIL '2022-01-01';CREATE ROLE my_username WITH CREATEDB CREATEROLE;CREATE ROLE my_username NOLOGIN;
Related[edit]
ALTER USERPostgreSQL: 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
- ERROR: permission denied to create role
See also[edit]
Advertising:
