Role Reassign/Drop Own Dialog v8
Use the Reassign/Drop Own dialog to change the ownership of database objects owned by a database role. This dialog instructs the system to change the ownership of database objects owned by any of the old_roles to new_role.
The Reassign/Drop Own dialog organizes the Reassign & Drop role through General tab.
- Use the Operation field to provide Reassign option.
- Provide a new role in the Reassign Objects to field; The ownership of all the objects within the selected database, and of all shared objects (databases, tablespaces), owned by the old_role will be reassigned to new_role.
- Provide a database on which the reassignment is to be carried out.
The above example demonstrates reassigning old_role to new_role.
Click the SQL tab to continue.
Removing database objects owned by a database role.
- Use the Operation field to provide Drop option.
- Use the Cascade? field to provide Yes, No is default.
- Provide a database on which the drop of objects is to be carried out.
Click the SQL tab to continue.
The above examples demonstrates drop owned by role.
- Click the Help button (?) to access online help.
- Click the OK button to save work.
- Click the Cancel button to exit without saving work.