Creating SQL Objects › Creating a Schema › Relating the Person to the AUTHID

Relating the Person to the AUTHID

Your PERSON occurrence, identified to CA Datacom Datadictionary with the user signon ID, must be related to a valid SQL AUTHORIZATION occurrence using the PER-ATZ-AUTHID relationship before you can use the Interactive SQL Service Facility. This is a many-to-one relationship, meaning that several PERSON occurrences can be related to a specific AUTHORIZATION occurrence. Several users can have the same default AUTHID, but each user can have only one default.

When you access the Interactive SQL Service Facility, CA Datacom Datadictionary checks for the existence of the relationship between your PERSON occurrence and a valid SQL AUTHORIZATION occurrence. If a relationship does not exist, CA Datacom Datadictionary presents the following panel.

 =>
 =>
 =>
 
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility
 
                                                                            S01A
                 Default Authorization Panel
 
 Please enter your default authorization ID and press Enter.
 
 AUTHID: __________________
 
 
 
 
 
 
 
 
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

The AUTHORIZATION occurrence you specify on this panel becomes your permanent default AUTHID, until you change it. You can change the AUTHID either temporarily for the session or permanently. See Changing Your AUTHID.

When the relationship exists, the Default Authorization Panel is not presented. The AUTHORIZATION occurrence is your default AUTHID and is displayed in the Current Authid field on the Source Member Panel.