Purpose
The AUTHID command, followed by an SQL authorization ID, changes your current authorization ID for the current session.
When to Use It
When you want to change your User Profile SQL authorization ID for any reason, such as displaying lists of tables for another ID. See Panels for more information.
If you change your SQL authorization ID with the PROFILE or AUTHID command, it changes only on your User Profile, and it does not change your PRIVATE SQL AUTHID which is maintained by the CA Dataquery for CA Datacom Administrator. Therefore, if you create a table in PDB, your permanent SQL authorization ID is attached to the table. However, if you DISPLAY tables or create or execute queries, the SQL authid currently specified on your user profile is used by CA Dataquery for CA Datacom.
Syntax
|
Enter |
With |
When You Want to: |
|---|---|---|
|
AUTHID |
SQL-authid |
Change authorization IDs. |
Example
=> AUTHID SYSUSR CREATION PANEL ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR CURRENT TABLE: ________________________________ ------------------------------------------------------------------------------- NAME: _______________ TYPE: QUERY STATUS: PRIVATE DESCRIPTION: ____________________________________________________________ ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== .. ..
Output
=> DQ353I - THE USER PROFILE WAS UPDATED SUCCESSFULLY. ------------------------------------------------------------------------DQZ50 DATAQUERY: MAIN MENU - SQL MODE ENTER THE NUMBER OF THE DESIRED FUNCTION ===> _ 1. DIRECTORIES - Lists of Queries and Tables 2. CREATE - Query, Dialog creation 3. GUIDE - Structured query creation 4. PDB - List, create and maintain personal tables 5. ADMINISTRATION - DATAQUERY system management 6. HELP - DISPLAY Help Information 7. OFF - DATAQUERY session termination
|
Copyright © 2014 CA.
All rights reserved.
|
|