PostgreSQL: CREATE USER

From wikieduonline
Jump to navigation Jump to search

create user, creates a new user in PostgreSQL

Examples

  • create user your_username

Create a new user:

create user your_username;
Output:
CREATE ROLE

Create a new user and assign a password:

CREATE USER your_username WITH ENCRYPTED PASSWORD 'your_pass';
Output:
CREATE ROLE
Assign a role with GRANT command:
GRANT your_defined_role TO your_username;

Related terms

See also

Advertising: