7. Changing Ownership of Databases and Database Objects : Changing Ownership of a Database Object : How to Change Ownership of a Database Object
 
Share this page                  
How to Change Ownership of a Database Object
Follow these basic steps to change ownership of a database object:
1. Take preparatory steps, as described in Prepare to Change Ownership of a Database Object.
2. Log in as the DBA of the database.
3. Use the relevant copy method to copy the object out of the database into an intermediate file.
4. Using the relevant copy method in input mode, copy the intermediate file into the new database as the new owner (by using the ‑u flag for commands, or by using the Users branch in the Virtual Nodes toolbar in VDBA).
There are now two copies of the object in the database, one owned by the original owner and one owned by the new owner.
5. To remove the original object, the DBA or privileged user uses the applicable Ingres tool as the original owner (by using the -u flag for commands, or by using the Users branch in the Virtual Nodes toolbar in VDBA) and deletes the original object.