Thank you in advance.
I realize only the superuser and table owner can change the ownership of a
table, but is there a way to modify the database owner privileges to do
the same?
Example:
userA is database owner and creates/owns 20 tables
superuser creates userB
superuser changes database owner to userB
userB cannot change userB cannot change ownership of userA_tables
I realize this was probably on purpose to set up the balance of power
between the table and database owner, but would there be a way to quickly
set the db owner's ability to change table owners in their database?
I'm hoping for a quick spot, maybe similar to the roles table, which would
require performing grants on all tables, but just updating a setting in
one place. I don't want userB to become superuser, just able to change
table owners.
Reason:
We have a lot of test databases with multiple db_owners, but very few
superusers, and table_owners switch all the time.