Postgres create user

This post will demonstrate how to list all users, permissions, and roles on a PostgreSQL database server.

Maintaining data security is paramount in any application or database deployment, and making sure users only have access to the data they need is the cornerstone of this security.

PostgreSQL has robust user, role, and permission management features, particularly with role based access that allows you to assign permissions to roles, and roles to users, making management tasks more straightforward and reducing the chance of accidentally assigning the wrong permissions to users.

As your database deployments grow, the number of users and their roles and permissions will also – increasing in not just in number and complexity.

It is important to regularly review permissions, and revoke those that are no longer required, and to effectively do so you need to be able to take an overview of your database security by inspecting all assigned permissions.

Connect to PostgreSQL as an Administrative Users

The default PostgreSQL user, named postgres has administrative rights for all dat

postgres show user permissions on database

postgres show user permissions on tables