CA Datacom - DBCA DatacomCA Datacom - ADCA Datacom - ServerCA CISCA Common Services for z/OSCA 90s ServicesCA Database Management Solutions for DB2 for z/OSCA Common Product Services ComponentCA Common ServicesCA Datacom/ADCA ecoMeter Server Component FOCCA Easytrieve Report Generator for Common ServicesCA Infocai MaintenanceCA IPCUnicenter CA-JCLCheck Common ComponentCA Mainframe VM Product ManagerCA Chorus Software ManagerCA On Demand PortalCA Service Desk Manager - Unified Self ServiceCA PAM Client for Linux for zSeriesCA Mainframe Connector for Linux on System zCA Graphical Management InterfaceCA Web Administrator for Top SecretCA CA- Xpertware
We have a couple of concern to provide the admin authority for the user who needs to make the data structure change in data dictionary. 1. How to locate the user ID -68K in Data dictionary? 2. How to get the display name of the user 3. Steps to authorize the user as admin Kindly provide the solution for the above concerns.
z/os, CA Datacom/DB 14.0 and higher
There are different ways to locate the Userid and related name (entity_name).
1- Via SQL, Using DBSQLPR, the requests could be: Select entity_name, userid from sysadm.person where status = 'P'; Select entity_name, userid from sysadm.person where status = 'P' and userid = '68K';
2- Via DDUTILTY report using SYSIN: //SYSIN DD * +USR DATACOM-INSTALL,NEWUSER +RPT DETAIL,PERSON /* Report, among other fields, displays Userid and Name. Do a find in your report output for '68K' in userid column.
3- Via DDOL, CICS transaction. a- signon b- go to Authorize and enter password (like 'Datacom-Install', 'Newuser' and then 'Newuser' on the next screen when asked to provide password). c- enter 1 - Maintain Person - option will list all the Name and userid. Scroll until you find ID '68K'
It displays panel T41U. It also displays column 'Profile' ($DD-ADM, $DD-UPD....etc) You may enter $DD-ADM in front of userid '68K' to give that user the profile $DD-ADM. $DD-ADM profile gives authority for managing (display,update) database structure.
The following DDUTILTY SYSIN will display all userid having $DD-ADM profile: //SYSIN DD * -RPT RELAT,AUTHORIZATION,$DD-ADM(PROD) -END and replace $DD-ADM with any other profile you may want.