oracledb_conf resource
Use the oracledb_conf Chef InSpec audit resource to test the Oracle system parameters.
Installation
This resource is distributed with Chef InSpec and is automatically available for use.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