Running Control-M/Server utilities as other users

Enables users who are not Control-M administrators to run Control-M/Server utilities.

To allow a user other than the Control‑M administrator to run Control‑M/Server utilities on a Windows computer, change the permissions of the following directories:

temp
proclog
prflag

The user requires the permission to write to these directories.

To access Control‑M/Server utilities from a UNIX user other than the Control‑M/Server account owner, the following modifications must be made to the user environment:

Define variables in the user environment
Add an executable library to the user’s path
Assign Read/Write permissions

The following environment variables must be defined:

CONTROLM_SERVER
CONTROLM_USER
CONTROLM_DATABASE
CONTROLM_MIRROR_USER
CONTROLM_MIRROR_DATABASE
CTM_DATABASE_TYPE
MIRROR_DB_SERVER
machine
LIBPATH, or LD_LIBRARY_PATH, or SHLIB_PATH

The following table lists additional environment variables that are required, according to the type of database:

For SYBASE	For ORACLE	For PostgreSQL
SYBASE	ORACLE_BASE	DB_TYPE
DSLISTEN	ORACLE_HOME	PGHOME
DSQUERY	ORACLE_SID	PGDATA
DSCONSOLE	NLS_LANG	PGPORT
MIRROR_DSLISTEN		PGHOST
MIRROR_DSQUERY		PGDATABASE
SYBASE_OCS, with the value of the Sybase client version (OCS-12_5 or OCS-15_0)		PGUSER
		PGSYSCONFDIR
		PGSERVICE
		LD_LIBRARY_PATH/LIBPATH/ SHLIBPATH
		DBU_BIN
		MIRROR_DSQUERY

Specify the following command for each variable from the Control-M user:

echo $<variableName>
echo $SYBASE

Use the formats in the following table to define the shared library path variables for each database in the user environment, depending on the server computer type:

Computer	Shared library environment variable name
AIX	LIBPATH
HP-UX	SHLIB_PATH
Solaris	LD_LIBRARY_PATH
Linux x86_64	LD_LIBRARY_PATH

For Sybase

Set the shared library environment variable value to:
~<controlmOwner>/ctm_server/exe_<opSysID>:$SYBASE/$SYBASE_OCS/lib

The variables in the library path are:
- <opSysID> is the identifier for the type of operating system
- <controlmOwner> is the user account home
  $SYBASE is the value for SYBASE from
  
  $SYBASE_OCS is the value for SYBASE from

For Oracle

Set the Shared library environment variable value to:
~<controlmOwner>/ctm_server/oracle/lib:~<controlmOwner>/ctm_server/
exe_<opSysID>

The variables in the library path are:
- <opSysID> is the identifier for the type of operating system from
- <controlmOwner> is the user account home from

For PostgreSQL

Set the Shared library environment variable value to:
~<controlmOwner>/ctm_server/exe_<opSysID>:~<controlmOwner>/pgsql/lib

The variables in the library path are:
- <opSysID> is the identifier for the type of operating system from
- <controlmOwner> is the user account home from

The following table describes the shared library path variables for Sybase, Oracle, and PostgreSQL:

Variable	Description
<Control-M/ServerPath>	The default full path name of the Windows home directory under which Control-M/Server is installed.
~<controlmOwner>	The default full path name of the UNIX user account home directory under which Control-M/Server is installed.
<opSysID>	Identifier for the type of operating system on the server computer (AIX, HP‑UX‑11, HP-UX-ia64, Solaris, Linux).

Setting environmental variables

Using csh or tcsh
Specify the following command for each variable:

setenv <variable-name> <value>

EXAMPLE: Sybase

setenv CONTROLM_SERVER /home/controlm/ctm_server

setenv SYBASE /home/controlm/sybase
setenv DSLISTEN CTRLM
setenv DSQUERY CTRLM
setenv DSCONSOLE CTRLM
setenv MIRROR_DSQUERY MIRROR
setenv MIRROR_DSLISTEN MIRROR
setenv ControlM_USER ctrlm
setenv ControlM_DATABASE ctrlm

setenv MIRROR_DB_SERVER ctrlm_mirror

setenv CTM_DATABASE_TYPE SYBASE

setenv CONTROLM_MIRROR_USER mirror_ctm

setenv CONTROLM_MIRROR_DATABASE mirror_ctm

setenv machine ${ControlM_SERVER}/scripts/sharch

setenv LD_LIBRARY_PATH ~<controlm_owner>/ctm_server/exe_Solaris:

/home/controlm/sybase/OCS-12_5/lib

Oracle

setenv CONTROLM_SERVER /home/ora_ctm/ctm_server

setenv ORACLE_HOME /home/ora_ctm/ctm_server/oracle

setenv ORACLE_SID ctrlm

setenv ORACLE_BASE /home/ora_ctm/ctm_server/oracle

setenv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
setenv CONTROLM_USER ctrlm
setenv CONTROLM_DATABASE ctrlm

setenv MIRROR_DB_SERVER ctrlm_mirror

setenv CTM_DATABASE_TYPE ORACLE

setenv CONTROLM_MIRROR_USER mirror_ctm

setenv CONTROLM_MIRROR_DATABASE mirror_ctm

setenv machine ${CONTROLM_SERVER}/scripts/sharch

setenv LD_LIBRARY_PATH /home/ora_ctm/ctm_server/exe_Linux-x86_64:
/home/ora_ctm/ctm_server/oracle/lib

PostgreSQL

setenv CONTROLM_SERVER /home1/ctm640pg/ctm_server

setenv CTM_DATABASE_TYPE PGSQL

setenv CONTROLM_DATABASE ctrlm640

setenv MIRROR_DSQUERY mirror

setenv CONTROLM_MIRROR_USER mirror2

setenv CONTROLM_MIRROR_DATABASE mirror2

setenv PRIMARY_DB_SERVER CTRLM

setenv MIRROR_DB_SERVER mirror

setenv BU_BIN /home1/ctm640pg/ctm_server/exe_Solaris

setenv PGPORT 5432

setenv PGDATABASE ctrlm640

setenv PGUSER ctmuser

setenv PGHOME /home1/ctm640pg/pgsql

setenv PGDATA /home1/ctm640pg/pgsql/data

setenv CONTROLM_USER ctmuser

setenv machine Solaris

setenv PG_HOST ctrlm640

setenv PG_SERVICE db

setenv LD_LIBRARY_PATH /home1/ctm640pg/ctm_server/exe_Solaris:/home1/ctm640pg/pgsql/lib

setenv :/home1/ctm640pg/pgsql/lib32:/home1/ctm640pg/ctm_server/exe_Solaris:/home1/ctm640pg/pgsql/lib:/home1/ctm640pg/pgsql/lib32:/home1/ctm640pg/ctm_agent/ctm/exe:/home1/ctm640pg/ctm_agent/ctm/exe

setenv DB_TYPE SERVER

setenv PGSYSCONFDIR /home1/ctm640pg/pgsql/etc

Using other shells
When using other shells (for example, sh, ksh), specify the following command for each variable:

<variable-name>=<value>; export <variable-name>

EXAMPLE: Sybase

CONTROLM_SERVER=/home/controlm/ctm_server; export CONTROLM_SERVER

SYBASE=/home/controlm/sybase; export SYBASE
DSLISTEN=CTRLM; export DSLISTEN
DSQUERY=CTRLM; export DSQUERY
DSCONSOLE=ctrlm; export DSCONSOLE
MIRROR_DSQUERY=MIRROR; export MIRROR_DSQUERY
MIRROR_DSLISTEN=MIRROR; export MIRROR_DSLISTEN
CONTROLM_USER=ctrlm; export CONTROLM_USER
CONTROLM_DATABASE=ctrlm; export CONTROLM_DATABASE

LIBPATH=/home/controlm/ctm_server/exe_HP-UX-11:/home/controlm/sybase/OCS-12_5/lib; export LIBPATH

Oracle

CONTROLM_SERVER=/home/controlm/ctm_server; export CONTROLM_SERVER

CONTROLM_USER=ctrlm; export CONTROLM_USER
CONTROLM_DATABASE=ctrlm; export CONTROLM_DATABASE

LIBPATH=/home/controlm/ctm_server/exe_HP-UX-ia64:
/home/controlm/oracle/lib; export LIBPATH

PostgreSQL

CONTROLM_SERVER=/home1/ctm640pg/ctm_server

CTM_DATABASE_TYPE=PGSQL

CONTROLM_DATABASE=ctrlm640

MIRROR_DSQUERY=mirror

CONTROLM_MIRROR_USER=mirror2

CONTROLM_MIRROR_DATABASE=mirror2

PRIMARY_DB_SERVER=CTRLM

MIRROR_DB_SERVER=mirror

DBU_BIN=/home1/ctm640pg/ctm_server/exe_Solaris

PGPORT=5432

PGDATABASE=ctrlm640

PGUSER=ctmuser

PGHOME=/home1/ctm640pg/pgsql

PGDATA=/home1/ctm640pg/pgsql/data

CONTROLM_USER=ctmuser

machine=Solaris

PG_HOST=ctrlm640

PG_SERVICE=db

LD_LIBRARY_PATH=/home1/ctm640pg/ctm_server/exe_Solaris:/home1/ctm640pg/pgsql/lib

:/home1/ctm640pg/pgsql/lib32:/home1/ctm640pg/ctm_server/exe_Solaris:/home1/ctm640pg/pgsql/lib:/home1/ctm640pg/pgsql/lib32:/home1/ctm640pg/ctm_agent/ctm/exe:/home1/ctm640pg/ctm_agent/ctm/exe

DB_TYPE=SERVER

PGSYSCONFDIR=/home1/ctm640pg/pgsql/etc

Adding an executable library to the path of the user

The executable directory of Control-M for Databases must be added to the path of the user. This path must include:

~<controlm_owner>/ctm_server/scripts

Using csh or tcsh
Use the following command to modify the path when using csh or tcsh:
- Sybase:
  set path=($path ${SYBASE}/OCS-12_5/bin ~<controlm_owner>/ctm_server/exe_<OS_ID>)
- Oracle
  set path=($path ${ORACLE_HOME}/bin ~<controlm_owner>/ctm_server/exe_<OS_ID>)

set path=($path $ {ORACLE_HOME}/bin~<controlm_owner>/ctm_server/exe_Solaris)

Using other shells
Use the following command to modify the path when using other shells (for example, sh, ksh):

PATH="$PATH: ~<controlm_owner>/ctm_server/exe_<OS_ID>"

PATH="$PATH: ~<controlm_owner>/ctm_server/exe_HP-UX-ia64"

Assign Read/Write permissions

The user must have the following read/write permissions:

Permission type	Directory
Read permission for file	<controlm‑directory>/.controlm
Read and Write permission for all files in directory	<controlm_owner>/ctm_server/prflag
If mirroring is enabled, Read permission for file	<controlm-directory>/.controlm_mirror
(PGSQL only) Write permissions for all files in directory	<controlm-directory>/pgsql/etc/pg_service.conf

You must provide security access to these files as follows:

Give group controlm read permission for the files.
All users who require access to Control-M utilities should belong to the same group as the Control-M/Server account as their primary group.

Parent Topic

Introduction to Utilities