Show Related--Collections

When you select a collection from the contents pane and select Show Related for that object, the Show Related dialog lists any objects with first-level dependencies on that collection. These objects can be: packages, procedures. You can view second-level dependencies by selecting Show Related for each object with a first-level dependency.

A collection is a group of associated packages. If you include a collection name in the package list when you bind a plan, any package in the collection becomes available to the plan. The collection can be empty when you first bind the plan. Later, you can add packages to the collection, and drop or replace existing packages, without binding the plan again.

Packages

When a users' access privilege is revoked from a collection any packages associated with that collection name are no longer accessible to that user. However, the package is still available to the user if the user has access privileges to a different collection that is associated with the same package.

Procedures

Return to main Show Related help window