The sysdba or oracleuser account privilege requirements for Oracle database instance discovery, monitoring and management by CommandCentral Storage.

Article:TECH55462  |  Created: 2007-01-12  |  Updated: 2007-01-15  |  Article URL http://www.symantec.com/docs/TECH55462
Article Type
Technical Solution

Product(s)

Environment

Issue



The sysdba or oracleuser account privilege requirements for Oracle database instance discovery, monitoring and management by CommandCentral Storage.

Solution



The following are the Oracle user account privilege requirements for CommandCentral Storage (CCS) to properly discover, monitor and Manage Oracle databases.  When setting up the Oracle sysdba or oracleuser user account privileges, the following associated Oracle commands must be provided for access to Oracle tables:

The username referred to below is any Oracle user used with CCS and created by sysdba user.

Grant connect, create view to username;
Grant select on sys.v_$datafile to username;
Grant select on sys.v_$tablespace to username;
Grant select on sys.v_$logfile to username;
Grant select on sys.v_$database to username;
Grant select on sys.v_$tempfile to username;
Grant select on sys.v_$instance to username;
Grant select on sys.v_$session to username;
Grant select on sys.v_$active_instances to username;
Grant select on sys.v_$filestat to username;
Grant select on sys.v_$parameter to username;
Grant select on sys.v_$sga to username;
Grant select on sys.v_$log to username;
Grant select on sys.dba_tablespaces to username;
Grant select on sys.dba_data_files to username;
Grant select on sys.dba_free_space to username;
 
When the CCS default auto-configuration is used, the default Oracle sysdba account needs to be set with these same privileges  When using manual discovery (manually configuring Oracle instances in CCS with own username/password) we need these same select privileges for username. The CCS explorer does not use or create its own user.



Legacy ID



294060


Article URL http://www.symantec.com/docs/TECH55462


Terms of use for this information are found in Legal Notices