Oracle Observations

March 31, 2008

BMC and O7_DICTIONARY_ACCESSIBILITY

Filed under: BMC — bigdaveroberts @ 4:05 pm

For those wishing to install BMC Patrol on an Oracle 8.1.7.4 database whit the init.ora parameter O7_DICTIONARY_ACCESSIBILITY is set to FALSE the following grants have to be performed as sys:

grant select on V_$DATAFILE to bmc;
grant select on V_$SESSION to bmc;
grant select on V_$SESSION_WAIT to bmc;
grant select on V_$LATCH to bmc;
grant select on V_$FILESTAT to bmc;
grant select on V_$LATCHNAME to bmc;
grant select on V_$SESS_IO to bmc;
grant select on V_$SQL to bmc;
grant select on V_$SESSTAT to bmc;
grant select on V_$LATCHHOLDER to bmc;
grant select on V_$PARAMETER to bmc;
grant select on V_$STATNAME to bmc;
grant select on DBA_USERS to bmc;
grant select on V_$DATABASE to bmc;
grant select on V_$SYSTEM_EVENT to bmc;
grant select on V_$SYSSTAT to bmc;
grant select on V_$SGA to bmc;
grant select on V_$ROWCACHE to bmc;
grant select on V_$SHARED_SERVER to bmc;
grant select on V_$SGASTAT to bmc;
grant select on V_$LOCK to bmc;
grant select on V_$LOG to bmc;
grant select on V_$ROLLSTAT to bmc;
grant select on DBA_ROLLBACK_SEGS to bmc;
grant select on DBA_DATA_FILES to bmc;
grant select on DBA_FREE_SPACE to bmc;
grant select on V_$LIBRARYCACHE to bmc;
grant select on V_$DISPATCHER to bmc;
grant select on DBA_TABLESPACES to bmc;
grant select on V_$PQ_SYSSTAT to bmc;
grant select on DBA_JOBS to bmc;
grant select on V_$ARCHIVED_LOG to bmc;
grant select on SM$TS_AVAIL to bmc;
grant select on DBA_OBJECTS to bmc;
grant select on V_$INSTANCE to bmc;
grant select on V_$ARCHIVE_DEST to bmc;
grant select on SM$TS_FREE to bmc;
grant select on V_$TEMP_SPACE_HEADER to bmc;

grant execute on DBMS_LOCK to bmc;
grant execute on DBMS_ALERT to bmc;
grant execute on DBMS_SYSTEM to bmc;

If the above are not performed then it will not be possible to compile the BMC$PKKPKG package.

NB. statements above assume BMC as the name of the BMC Oracle user account.

Blog at WordPress.com.