Use the RESET DEFAULT AUTHID xxxxxxxxxxxxxxxxxx command, where the x's represent the 1 to 18 characters of an existing SQL AUTHORIZATION occurrence name, to change your default authorization ID. When the command completes successfully, the current PER-ATZ-AUTHID relationship is deleted and the new one is added.
Alternately, see the CA Datacom Datadictionary Online Reference Guide for information on deleting and adding relationships. You can use the online functions to change the PER-ATZ-AUTHID relationship and establish a new default authorization ID.
To change to your default AUTHID later in the session or to temporarily change the AUTHID, use the AUTHORIZATION-ID Panel. Obtain an AUTHORIZATION-ID Panel by either using the SET AUTHID command or by selecting the SET AUTHID function on the SQLADMIN Panel (see Setting the Session Authorization ID). When you have obtained an AUTHORIZATION-ID Panel, you can change to the default AUTHID by pressing PF9 (EXECUTE) without placing an entry on the panel. Or, if you want to temporarily change the AUTHID, you can reset it by placing an entry on the AUTHORIZATION-ID Panel and pressing PF9 (EXECUTE). In either case, after you press PF9 CA Datacom Datadictionary returns a message to the panel naming the authorization ID now in effect. Reset AUTHIDs remain in effect for the duration of the session or until again changed.
If you establish a session AUTHID and subsequently issue a RESET DEFAULT AUTHID command, the session AUTHID continues to be used during the current session.
|
Copyright © 2014 CA.
All rights reserved.
|
|