Granting and Revoking Privileges

Database user

In PostgreSQL, a database user is an account that’s used to connect to a PostgreSQL database. A user is identified by a name and can have a password, permissions, and other attributes that control how the user can access and interact with the database.

Creating a database user

Creating a database user in PostgreSQL is a simple and necessary task for managing access to our databases. We use the CREATE USER command followed by the username (of the user) we wish to create.