Ownership transfer can be specific to an individual object, or multiple objects can be transferred in one command. Use preserve permissions to preserve explicitly granted permissions of an object.
For syntax, see alter...modify owner in Reference Manual: Commands.
In this example, the database owner transfers a table owned by john to eric.
alter table john.table_audit modify owner eric
To transfer the ownership of all tables owned by john to eric, a system security officer can execute:
alter table john.* modify owner eric
To transfer the ownership of all objects owned by john to eric, a system security officer can execute:
alter all john.* modify owner eric
