PostgreSQL | Creating Roles (Users)

Tags:

PostgreSQL roles are generally classified as users and groups. This section explains procedures such as creating and deleting roles and granting privileges to roles.

PostgreSQL | Role (User) ROLE Creation | Create a Role (CREATE ROLE)

PostgreSQL | Role (User) ROLE Creation | List Created Roles

PostgreSQL | Role (User) ROLE Creation | Change Role Attributes and Name (ALTER ROLE)

PostgreSQL | Role (User) ROLE Creation | Rename a Role (ALTER ROLE)

PostgreSQL | Role (User) ROLE Creation | Set Role Password Expiration (ALTER ROLE)

PostgreSQL | Role (User) ROLE Creation | Grant Privileges on Tables, Views, and Other Objects (GRANT)

PostgreSQL | Role (User) ROLE Creation | Remove Role Privileges (REVOKE)

PostgreSQL | Role (User) ROLE Creation | Change Ownership of Objects Owned by a Specified Role to Another Role (REASSIGN OWNED)