Authorities and privileges
The Show Related notebook shows the immediate relationship between objects. You will only see the first level subordinate dependencies for an object. For example, if you want to drop TableA you will need to know what views are affected. On the Views page of the Show Related notebook for TableA you see ViewA. ViewA has a first level dependency on TableA. If another view, ViewB, was built on ViewA, it would have a first level dependency on ViewA and a second level dependency on TableA. You will not see ViewB listed in the Show Related notebook for TableA. You must right-click on the ViewA object in the notebook and select Show Related from the popup menu to see the dependencies on ViewA. You can look at Show Related for as many levels of dependencies as exist.
The pages in this notebook vary according to the object that you selected. The following list explains what you see for each object.
Related objects are packages, plans, tables and views. Dropping an alias has no effect on any view or synonym that was defined using the alias
.
Related objects are databases, indexes, and table spaces.
Related objects are aliases, databases, indexes, packages, plans, synonyms, table spaces, and views. Catalogs are related to all objects in the Control Center object tree. If you delete a catalog, you damage all of the objects that are represented in the catalog.
Related objects are packages and procedures.
Related objects are indexes, storage groups, tables, and table spaces. If you drop a database, all of its table spaces, tables, and indexes are also dropped.
Related objects are aliases, packages, plans, synonyms, tables, views, table spaces, collections, databases, indexes, procedures, and storage groups.
Related objects are buffer pools, databases, DB users, packages, plans, and storage groups.
Related objects are aliases, indexes, plans, synonyms, tables, table spaces, and views. Whenever a package is dropped, all plans dependent on the execute privilege of the package are invalidated. All privileges on the package are dropped.
Related objects are aliases, indexes, packages, synonyms, tables, table spaces, and views.
The related object is collections.
Related objects are databases and indexes.
Related objects are packages, plans, tables, and views.
Related objects are aliases, databases, DB users, packages, plans, synonyms, and views.
Related objects are buffer pools, catalogs, databases, DB users, packages, and plans.
Related objects is trigger packages. Trigger packages can only be dropped by dropping the associated trigger.
Related objects are plans and packages. When a user-defined function is dropped all privileges on the function are also dropped.
Related objects are cast functions and their privileges. Whenever a UDF or distinct type is dropped, all privileges on the distinct type are also dropped. In addition, the cast functions that were generated when the distinct type was created and the privileges on those cast functions are also dropped.
Related objects are aliases, packages, plans, synonyms, base tables, base views, and views.