wiki:ztvclsaInsert

Version 1 (modified by lttoth@…, 7 years ago) (diff)

--

Creating New Basic Associated Classes in ZUAUSR

Until ZUAUSR has been replaced by a more suitable tool, occasionally a new basic class must be created. One notable example is when we remove functions from ZUAUSR that are no longer requested via that mechanism, but Security Coordinators want a reminder that they need to request termination of a privilege. Another example is when a new Banner class is created to handle a particular circumstance and that new function will have roles granted in ZUAUSR.

The following topics are discussed:

  • Replacing Previous Functions with a Place Holder Class
  • Creating New Banner Classes

Replacing Previous Functions with a Place Holder Class

At one time the following class existed in ZUAUSR

TypeInstanceClass Name
UNIXTALKEETNASSH_TALKEETNA

This class was associated with several complex SUPER classes and each time the SUPER class was added, ZUAUSR administrators would ask OIT-Technical Services to create a Shell account for that user. We found that the accounts were rarely used. We were causing unnecessary work for ZUAUSR administrators and OIT-TS.

All instances of the class were deleted from ZUAUSR and a placeholder class was created. This type of class has to be a SUPER class or Security Coordinators can not see it to select.

TypeInstanceClass Name
SUPERPRODSSH_CSM_TO_ADD_OR_DROP_CLS

The instance is immaterial; it could have been Talkeetna, but I left it as PROD to indicate production. The class was created with the following statement:

INSERT INTO ztvclsa
(ztvclsa_class_type, ztvclsa_class_inst, ztvclsa_class_name)
VALUES
('SUPER','PROD','SSH_CSM_TO_ADD_OR_DROP_CLS')

Creating New Banner Classes

At this point, creating new Banner classes is discouraged, but there have been circumstances when it has been unavoidable. Case in point, moving all training off of TRNX database instance to PREP database instance necessitated creating a class that only allowed visibility to training functions rather than HR and Finance test functions.

Two groups take steps to install a new Banner Class into ZUAUSR. EAS defines the class and adds roles as appropriate. Once that is done, ZUAUSR administrators make it known to ZUAUSR via a script run in SQLPLUS by zuausr@prod. See ZUAUSR Technical Guide v3.0; refresh_ZUAUSR_base_banner_classes, pg 17.

The class was created with the following fields:

Field NameValue
ZTVCLSA_CLASS_INSTPREP
ZTVCLSA_CLASS_NAMETRAINING
ZTVCLSA_CLASS_TYPEBANNER
ZTVCLSA_CLASS_ATTR_NAME
ZTVCLSA_DESCRIPTION
ZTVCLSA_SECURITY_LEVEL
ZTVCLSA_APPROVAL_FLAG
ZTVCLDA_BAD_CLASS_FLAG

See