How To Give Permission To a User On PostgreSQL

 

In this article we will examine how to give permission to a user in PostgreSQL.

You should click on the Postgres menu item for other PostgreSQL articles.

You can give permission to a user on an object with the command below.

 

Example1:

Give permission on database:

 

Below you will find the kinds of permissions you can give on the database.

 

Example2:

Give permission on the object:

 

Example3:

Give all tables in a schema:

 

Example4:

Give all permissions on database:

 

Example5:

If you put the following command at the end of the above scripts, the relevant user can also give permissions to others.

 

You may want to look at the link below for more detailed authorization types.

https://www.postgresql.org/docs/9.0/static/sql-grant.html

 

 

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *