Enhanced Object Security › Define the CA IDMS Visual DBA profile › End User

End User

The following profile could be used by an end user who has full control of SQL Schema's that start with DEMO in dictionary SYSDICT and to Non-SQL Schema's in dictionary SYSDICT that start with EMP .

In addition this end user has read access to all Table Like objects in dictionary SYSDICT.

The only command console processor that can be used in the profile is SQL and only against dictionary SYSDICT. Through the (F) specification for Activity, this profile allows for creating searches in the online IDMS log.

add module name is VIDMS_ENDUSER version is 1
           include user JOESIXP registered for all
           public access allowed for DISPLAY
           module source follows
SQL Schema[SYSDICT]/DEMO*(F)
Non SQL Schema[SYSDICT]/EMP*(F)
Table Like[SYSDICT]
Activity(F)
Statistics
*
Cmd Console SQL/SYSDICT
          msend.

After a successful connection, expansion of SQL Schema [SYSDICT] DEMO* and selection of Non-SQL Schema [SYSDI CT] EMP*, the CA IDMS Visual DBA tree looks like: