You can delete resources or metadata objects for which you have write permission on the resource or metadata object and all the child objects. If you do not have write permission on all the child objects, Metadata Manager deletes any child objects on which you have write permission that do not have any child objects.

For example, you created a custom resource, AccessDB, with a schema object ACCESS_DB_SOURCE. ACCESS_DB_SOURCE contains a child table object named CUSTOMERS. CUSTOMERS has no child objects. If you have write permissions on the resource and all objects and delete the resource, Metadata Manager deletes the resource and all child objects. However, if you have read permission on ACCESS_DB_SOURCE and write permission on CUSTOMERS, and delete the resource, Metadata Manager only deletes CUSTOMERS.

You can use the

Actions

menu or right-click menu to delete a resource or object from the following

Catalog

view on the

Browse

tab.