Enhanced Object Security › Define the CA IDMS Visual DBA profile › Programmer

Programmer

The following profile could be used for programmers that have only read access to SQL schema's in dictionary SYSDICT that start with DEMO and to Non-SQL Schema's in dictionary SYSDICT that start with EMP .

This profile does allow full control of all Records and Modules in dictionary SYSDICT.

Command consoles are not available when using this profile. Through the (F) specification for Activity, this profile allows for creating searches in to the online IDMS log.

add module name is VIDMS_PROGRAM_DEMO version is 1
           include user JOESIXP registered for all
           public access allowed for DISPLAY
           module source follows
SQL Schema[SYSDICT]/DEMO*
Non SQL Schema[SYSDICT]/EMP*
IDD Class & Record & Module[SYSDICT](F)
Activity(F)
Statistics
           msend.

The CA IDMS Visual DBA tree after a successful connection looks like this: