postgreSQL Grant OR Revoke user Privileges

Cluster level:

• Granted to a user during CREATE or later using ALTER USER
  These privileges are granted by superuser

Object Level:

• Granted to user using GRANTcommand
• These privileges allow a user to perform particular action on an database object, such as table, view, sequence etc.

• Can be granted by Owner, superuser or someone who have been given permission to grant privilege (WITH GRANT OPTION)

Grant statement:

• GRANT can be used for granting object level privileges to database users, groups or roles.
• Privileges can be granted on a tablespace, database, schema, table, sequence, domain and function.
• GRANT is also used to grant a role to a user.

Syntax:
-Type \h GRANT in edb-psqlterminal to view the entire syntax and available privileges that can be granted on different objects

Grant commad

Revoke statement:

• REVOKE can be used for revoking object level privileges to database users, groups or roles.
• Privileges can be revoked on a tablespace, database, schema, table, sequence, domain and function.
• REVOKE [ GRANT OPTION FOR ] can be used to revoke only the grant option without revoking the actual privilege.

Syntax:
-Type \h REVOKE in edb-psqlterminal to view the entire syntax and available privileges that can be revoked on different objects.

also see below

what is postgreSQL

Why postgresSQL

History of PostgreSQL

postgreSQL - PSQL MATA Commands

postgreSQL what is schema?

postgreSQL Connecting to a Database

postgreSQL Create and access Database

How to create user in postgreSQL?

postgreSQL Grant/Revoke Privileges

postgreSQL Tablespaces and datafiles

postgreSQL How to start server and stop server?

postgreSQL perfomance

postgreSQL How to create cluster?

postgreSQL Queries

postgreSQL routine maintenance and proactive-maintanace.

postgresql-logging