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.