Creating a Control-M user in an Oracle database

This procedure describes how to create a Control-M user in an Oracle database. The database administrator must create this user before you install Control-M without defining the database username and password.

To create a Control-M user in an Oracle database:

1. Create table space with name that does not consist of one of the following strings:
   • users
   • example
   • temp
   • system
   • sysaux
   • perfstat

   BMC recommends the following table space features:

   • logging (Oracle default)
   • size
   • auto extend on extend management: automatic allocation (Oracle default)
   • segment space management automatic (Oracle default)
   • Compression BASIC (Workload Archiving only)
   • BIGFILE (Workload Archiving only)

   EXAMPLE: CREATE TABLESPACE "MY_TABLESPACE" LOGGING DATAFILE 'E:\ORACLE11\ORADATA\ORCL\MY_TABLESPACE.ora' SIZE 250M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

2. Create a profile with Oracle defaults, but it is strongly recommended to use the following profile features:
   • Unlimited idle time
   • Unlimited password life time

   EXAMPLE: create profile BMC_PROFILE_$USERNAME limit idle_time unlimited password_life_time unlimited

3. Create role in the database to use for the Control-M user.

   EXAMPLE: create role BMC_ROLE_$USERNAME

4. Assign the following permissions to the created role:
   • alter session
   • create procedure
   • create sequence
   • create session
   • select any dictionary
   • create synonym
   • create table
   • create trigger
   • create view

   EXAMPLE: grant alter session,create procedure,create sequence,create session,select any dictionary,create synonym,create table,create trigger,create view to BMC_ROLE_CTMUSER;

5. Create a database username that does not consist of one of the following strings and assign the created table space, profile, and role to it:
   • anonymous
   • perfstat
   • public
   • scott
   • sys
   • sysman
   • system

   EXAMPLE: create user CTMUSER identified by CTMPASS default tablespace $TABLESPACE_NAME quota unlimited on $TABLESPACE_NAME profile BMC_PROFILE_$USERNAME

6. Grant explicit permissions to the user, as follows:
   • grant create table to CTMUSER;
   • grant create view to CTMUSER;
   • grant select any dictionary to CTMUSER;