[edit on GitHub]

Use the oracledb_conf Chef InSpec audit resource to test the Oracle system parameters.

Installation

This resource is distributed along with Chef InSpec itself. You can use it automatically.

Requirements

You must have access to a database user with DBA role.

Syntax

A oracledb_conf resource block declares user and password to use. It fetches system parameters which are defined in the V$SYSTEM_PARAMETER database view, and then compares those parameters to the values stated in the test:

describe oracledb_conf(user: 'USER', password: 'PASSWORD') do
  its("config item") { should cmp "value" }
end

Optional Parameters

oracledb_conf is based on oracledb_session, and accepts all parameters that oracledb_session accepts.

Examples

The following examples show how to use this Chef InSpec audit resource.

Test parameters set within the database view

describe oracledb_conf(user: 'USER', password: 'PASSWORD') do
  its("audit_sys_operations") { should cmp "true" }
  its("sql92_security") { should cmp "true" }
end

Matchers

For a full list of available matchers, please visit our matchers page.