Creating SQL Objects › Creating a Schema › Displaying and Reporting

Displaying and Reporting

You can display a table of AUTHORIZATION entity-occurrences using the CA Datacom Datadictionary Entity Display (ENTDISPL) Mode and view the attributes to determine if AUTH-USAGE=S. This indicates it is a valid SQL authorization ID. See the CA Datacom Datadictionary Online Reference Guide for information on the Entity Display Mode.

You can also run a batch report using the -RPT SCHEMA transaction to list all valid SQL authorization IDs and objects owned by each. See the CA Datacom Datadictionary Batch Reference Guide for information on the Schema Report.