Enhanced Object Security › CA IDMS Visual DBA Objects Security

CA IDMS Visual DBA Objects Security

Setting up appropriate CA IDMS Visual DBA user profiles is the easiest way to control access to CA IDMS dictionaries and run time data by CA IDMS Visual DBA users.

The remaining of this chapter gives information on the SQL objects defined for use by CA IDMS Visual DBA. Access to these SQL objects and their associated resources by other CA IDMS client applications must be controlled and optionally secured. Because CA IDMS Visual DBA is an SQL client application, its users also need to be granted privileges for all the accessed resources.

The names of the resources, which are of type TABL, are in the form schema‑name.table-name. The objects in the following schema's are for exclusive use by CA IDMS Visual DBA:

• SYSVNTWK5 contains views on objects in the DDLDML area of dictionary
• SYSVSYST5 contains views on objects in the DDLCAT area of dictionary
• SYSTSCHM5 is used for access to the Non-SQL schema IDMSNTWK (non Sysgen)
• SYSTSYST5 is used for access to the Non-SQL schema IDMSNTWK (Sysgen)
• IDMSSECS5 is used for access to the Non-SQL schema IDMSSECS
• IDMSSECU5 is used for access to Non-SQL schema IDMSSECU

The following table procedures and functions in schema SYSCA are also for use by CA IDMS Visual DBA:

• SYSCA.VDBA_DICTIONARY5 definition only
• SYSCA.VDBA_VERSION5 definition only
• SYSCA.VDBAIDD5 for executing BCF/OCF, IDD, Schema, SSC, and Sysgen compilers
• SYSCA.VDBADCT5 for executing DCMT commands
• SYSCA.VDBADCU5 for executing DCUF commands
• SYSCA.VDBALOG5 for viewing the LOG database
• SYSCA.VDBAQNC5 for viewing columns of Non-SQL Schema's
• SYSCA.VDBAGET5 generic function
• SYSCA.VDBA_CONV2CHAR5 generic function