Security Database Information and DSECTs

You can access security information in the following ways:
idms
You can access security information in the following ways:
  • Issuing DISPLAY statements through the CA IDMS Command Facility
  • Issuing SQL DML statements through the CA IDMS Command Facility
  • Issuing navigational or SQL DML statements to access the data from CA technologies OLQ, CA technologies Culprit, or a user-written program
Security DISPLAY statements
What You Can Do
You can submit to the CA IDMS Command Facility DISPLAY or PUNCH statements to display this security information:
  • About global resources:
    • Holders of SYSADMIN privilege
    • User information, including definitions, groups, and privileges
    • Group information, including definitions, users, and privileges
    • User profile information, including attributes
  • About system resources:
    • Holders of DCADMIN privilege
    • Resource definitions
    • Privileges granted on resources
  • About database resources:
    • Resource definitions
    • Privileges granted on resources
Documentation of DISPLAY Statements
For documentation of DISPLAY statement syntax, see Syntax for Security Display Statements.
DML Access
Navigational DML
For navigational DML access to a security database, you specify the appropriate security subschema and issue DML statements to navigate the security records that are described later in this section.
You can issue navigational DML statements through CA OLQ, CA Culprit, or a user-written program to access the user catalog through subschema IDMSSECU and other security definitions in the system dictionary through subschema IDMSSECS. You cannot access SQL-defined database resources through navigational DML.
SQL DML
For SQL access to information on global and system resources, you define SQL schemas for the non-SQL-defined security schemas (IDMSSECU and IDMSSECS) and issue SQL statements that specify records in the security databases as tables.
Security information on SQL-defined database resources resides in the SQL-defined tables in the SYSTEM schema that are described later in this section.