What user privileges are needed for SCM to run checks against an Oracle instance on Unix? (NETIQKB56490)

What user privileges are needed for SCM to run checks against an Oracle instance on Unix?

What tables does SCM use when running Oracle on Unix checks?

Prerequisites

• Secure Configuration Manager 5.6 or Secure Configuration Manager 5.7
• NetIQ Security Agent for Unix 5.6

Oracle Endpoint Requirements

• Oracle Database version  9i / 10g
• User account:
• Connect privilege to specific DB instance
• Select privilege to tables and views for the following tables:
  • Sys.obj$
  • sys.link$
  • v$database
  • dba_libraries
  • dba_profiles
  • dba_users
  • dba_policies
  • dba_procedures
  • dba_proxies
  • dba_roles
  • dba_role_privs
  • dba_tab_privs
  • role_sys_privs
  • dba_sys_privs
  • dba_tables
  • dba_views
  • dba_data_files
  • dba_free_space
  • dba_ts_quotas
  • v$instance
  • v$version
  • v$parameter
  • v$logfile
  • v$controlfile
• Valid database instance name. DBA PROVIDED
• Valid oratab path known if not default. DBA PROVIDED

Formerly known as NETIQKB56490