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

  • 7756490
  • 02-Feb-2007
  • 10-Apr-2009

Environment

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

Situation

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?

Resolution

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

Additional Information

Formerly known as NETIQKB56490

 


Feedback service temporarily unavailable. For content questions or problems, please contact Support.