Previous Topic: Current Authorization ID at Start of SessionNext Topic: How to Set the Default

Performing SQL Administrative Tasks › Setting the Session Authorization ID › Displaying and Reporting

Displaying and Reporting

You can display a table of AUTHORIZATION entity-occurrences using the Entity Display (ENTDISPL) Mode of CA Datacom Datadictionary online 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 the schema represented by each AUTHID. See the CA Datacom Datadictionary Batch Reference Guide for information on the Schema Report.