Skip to main content

PostgreSQL Permissions

Here are three major points you need to understand about object ownership:

  1. Only a superuser or the owner of an object (table, function, procedure, sequence, etc.) can ALTER/DROP the object.

  2. Only a superuser or the owner of an object can ALTER the ownership of that object.

  3. Only the owner of an object can define default privileges for the objects they create.

Back to top