Naming Conventions Policy for Database Objects

The following table provides a checklist which specifies the CA Technologies naming convention policy. If your database naming convention is different from the CA Technologies policy, then fill in the appropriate row with the different naming convention. Consult the CA Support department before running the installation.
bsi
The following table provides a checklist which specifies the CA Technologies naming convention policy. If your database naming convention is different from the CA Technologies policy, then fill in the appropriate row with the different naming convention. Consult the CA Support department before running the installation.
CA Naming Convention
Customer Naming Convention
Tablespace
 
TBS_ACE_DATA_TAB_01
 
TBS_ACE_INDEX_TAB_01
 
TBS_CSL_DATA_TAB_01
 
TBS_CSL_INDEX_TAB_01
 
TBS_DASH_DATA_01
 
TBS_DASH_INDEX_01
 
TBS_LOB_DATA_01
 
TBS_OBL_DATA_01
 
TBS_OBL_INDEX_01
 
TBS_PSL_DATA_TAB_01
 
TBS_PSL_INDEX_TAB_01
 
TBS_OBLIDBADMIN_01
 
TBS_SLA_DATA_01
 
TBS_SLA_DATA_02
 
TBS_SLA_INDEX_01
 
TBS_SLA_INDEX_02
 
TBS_SMI_DATA_TAB_01
 
TBS_SMI_INDEX_TAB_01
 
TBS_SMIANA_DATA_TAB_01
 
TBS_SMIANA_INDEX_TAB_01
 
CA TECHNOLOGIES USERS
 
OBLICORE
 
OBLIDBADMIN
 
OBLIDBADMIN PRIVILEGES
 
CONNECT TO OBLIDBADMIN
 
UNLIMITED TABLESPACE TO OBLIDBADMIN
 
EXECUTE ON DBMS_LOCKTO OBLIDBADMIN
 
SELECT ANY DICTIONARY TO OBLIDBADMIN
 
CREATE PUBLIC SYNONYM TO OBLIDBADMIN
 
DROP PUBLIC SYNONYM TO OBLIDBADMIN
 
CREATE ANY SYNONYM TO OBLIDBADMIN
 
DROP ANY SYNONYM TO OBLIDBADMIN
 
CREATE TABLE TO OBLIDBADMIN
 
CREATE VIEW TO OBLIDBADMIN
 
CREATE SEQUENCE TO OBLIDBADMIN
 
ROLE_USR_REG_PRIVS TO OBLIDBADMIN WITH ADMIN OPTION
 
ALTER DATABASE TO OBLIDBADMIN
 
ALTER SESSION TO OBLIDBADMIN
 
EXECUTE ANY PROCEDURE TO OBLIDBADMIN
 
SELECT ANY TABLE TO OBLIDBADMIN
 
GRANT ANY OBJECT PRIVILEGE TO OBLIDBADMIN
 
GRANT ANY PRIVILEGE TO OBLIDBADMIN
 
CREATE TABLESPACE TO OBLIDBADMIN
 
ALTER TABLESPACE TO OBLIDBADMIN
 
DROP TABLESPACE TO OBLIDBADMIN
 
CREATE USER TO OBLIDBADMIN
 
ALTER USER TO OBLIDBADMIN
 
DROP USER TO OBLIDBADMIN
 
CREATE ROLE TO OBLIDBADMIN
 
ALTER ANY ROLE TO OBLIDBADMIN
 
DROP ANY ROLE TO OBLIDBADMIN
 
CREATE ANY TABLE TO OBLIDBADMIN
 
ALTER ANY TABLE TO OBLIDBADMIN
 
DROP ANY TABLE TO OBLIDBADMIN
 
CREATE ANY INDEX TO OBLIDBADMIN
 
ALTER ANY INDEX TO OBLIDBADMIN
 
DROP ANY INDEX TO OBLIDBADMIN
 
CREATE ANY PROCEDURE TO OBLIDBADMIN
 
ALTER ANY PROCEDURE TO OBLIDBADMIN
 
DROP ANY PROCEDURE TO OBLIDBADMIN
 
CREATE ANY SEQUENCE TO OBLIDBADMIN
 
ALTER ANY SEQUENCE TO OBLIDBADMIN
 
DROP ANY SEQUENCE TO OBLIDBADMIN
 
CREATE ANY TRIGGER TO OBLIDBADMIN
 
ALTER ANY TRIGGER TO OBLIDBADMIN
 
DROP ANY TRIGGER TO OBLIDBADMIN
 
CREATE ANY TYPE TO OBLIDBADMIN
 
DROP ANY TYPE TO OBLIDBADMIN
 
CREATE ANY VIEW TO OBLIDBADMIN
 
DROP ANY VIEW TO OBLIDBADMIN
 
USRACE
 
USRCSL
 
USRDASH
 
USREDR
 
USRMTN
 
USRPSL
 
USRRPT
 
USRSLA
 
OBLICORE PRIVILEGES
 
CONNECT TO OBLICORE
 
UNLIMITED TABLESPACE TO OBLICORE
 
EXECUTE ON DBMS_LOCK TO OBLICORE
 
SELECT ANY DICTIONARY TO OBLICORE
 
CREATE PUBLIC SYNONYM TO OBLICORE
 
DROP PUBLIC SYNONYM TO OBLICORE
 
CREATE ANY SYNONYM TO OBLICORE
 
DROP ANY SYNONYM TO OBLICORE
 
CREATE TABLE TO OBLICORE
 
CREATE VIEW TO OBLICORE
 
CREATE SEQUENCE TO OBLICORE
 
CREATE SESSION TO USRCSL
 
ROLE_USR_REG_PRIVS TO USRCSL
 
CREATE SESSION TO USRDASH
 
ROLE_USR_REG_PRIVS TO USRDASH
 
CREATE SESSION TO USREDR
 
ROLE_USR_REG_PRIVS TO USREDR
 
CREATE SESSION TO USRMTN
 
ROLE_USR_REG_PRIVS TO USRMTN
 
CREATE SESSION TO USRPSL
 
ROLE_USR_REG_PRIVS TO USRPSL
 
CREATE SESSION TO USRRPT
 
ROLE_USR_REG_PRIVS TO USRRPT
 
CREATE SESSION TO USRSLA
 
ROLE_USR_REG_PRIVS TO USRSLA
 
OBLICORE ROLE
 
ROLE_USR_REG_PRIVS
 
PART_MNG_PKG
For raw data partitioning. If this system does not use this feature, then it does not have to run.
DB_MNG_FORECAST_PKG -
Forecast calculations. If this system does not use this feature, then it does not have to run. This feature was developed for using partitioning on T_PSL (which was never activated), so currently it is not in use.
DB_MTN_PKG.LOG_PURGE -
Responsible for cleaning t_log table
DB_MTN_PKG.COLLECT_STATS -
Database statistics collection
PRC_T_INTER_REGISTRATIONS_FLAT -
Builds a table with all (direct and indirect) connections between metrics by the use of event reusability. Serves the raw data reports where there is a use of event reusability.