PostgreSQL Permissions

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

 

 

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

 

 

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

 

 

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