Performing SQL Administrative Tasks › Setting the Session Authorization ID › Current Authorization ID at Start of Session

Current Authorization ID at Start of Session

When you enter the Interactive SQL Service Facility of online CA Datacom Datadictionary, your default authorization ID is one of the following:

• An AUTHID established with CA Datacom Datadictionary functions to relate your PERSON occurrence to an SQL valid AUTHORIZATION occurrence using the PER-ATZ-AUTHID relationship. (For information on adding relationships between occurrences, see the CA Datacom Datadictionary Batch Reference Guide or CA Datacom Datadictionary Online Reference Guide.)
• An AUTHID established with the Default Authorization Panel or the RESET DEFAULT AUTHID command. (See Changing Your AUTHID.)

The SET AUTHID command in the SQLADMIN facility allows you to temporarily change the default authorization ID during an online session in the Interactive SQL Service Facility. Changing the default is useful when you want to process DML statements against tables belonging to another schema without having to qualify those tables with the authorization ID.

Note: This option does not create a new authorization ID. If you want to create a new authorization ID, see Creating a Schema.

The default authorization ID is the one CA Datacom Datadictionary uses with any executions of SQL members in the Interactive SQL Service Facility. If the SQL statements in the source member being executed do not make an explicit reference to an authorization ID, CA Datacom Datadictionary uses the current default authorization ID.

You can switch to any valid SQL authorization ID. If the specified authorization ID is not valid, the switch does not take place and the current authorization ID in effect remains intact for the session.