Privilege

A permission which can be granted on objects

A privilege is a permission which can be granted on objects owned by another user.

Privilege types

Following privileges can be granted, depending on the object type:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • TRUNCATE
  • REFERENCES
  • TRIGGER
  • CREATE
  • CONNECT
  • TEMPORARY
  • EXECUTE
  • USAGE

Privilege functions

Following functions are available to query user privileges on various types of objects:

Categories

PostgreSQL concept, User management