Site icon Database Tutorials

How To List Database Permissions In PostgreSQL

In today’s article, we will talk about How To List Database Permissions In PostgreSQL.

In some cases, we may need to create a different user in a database and give select, insert, update and delete privileges to only some tables.

You have a large number of tables and if you want to see which table you have authorized, you can use the plpgsql script below.

When you run the above command, it will show the permissions in the tables and views as follows.

 

 

 

Exit mobile version