create_sql_configuration

This command defines the connection between an S-TAP® and an Oracle server used for Oracle unified auditing.

This API is available in Guardium V11.1 and later.

REST API syntax

This API is available as a REST service with the POST method. Call this API as follows: 
POST https://[Guardium hostname or IP address]:8443/restAPI/create_sql_configuration

GuardAPI syntax

create_sql_configuration parameter=value

Parameters

Parameter Value type Description
dbType String Required. The type of data repository being monitored. Valid value:
  • Oracle
instance String Required. String that specifies the connection identifier in the tnsnames.ora that is used to connect to the database.
dataPullInterval String Time, in seconds, between attempts to pull data from the database.

Default=30
dataPullRows String Number of rows of auditing data to pull in a single pass.

Default=100
stapHost String Required. For valid values, call create_sql_configuration from the command line with --help=true.
timeout String Time, in seconds, to allow the database to respond.

Default=300000
username String Required. Username for logging in to the Oracle DB.
userRole String Role for logging in to the Oracle DB. Valid values
  • "
  • sysdba
  • sysoper

Default = "
api_target_host String

Specifies the target hosts where the API executes. Valid values:
  • all_managed: execute on all managed units but not the central manager
  • all: execute on all managed units and the central manager
  • group:<group name>: execute on all managed units identified by <group name>
  • host name or IP address of a managed unit: specified from the central manager to execute on a managed unit.  For example, api_target_host=10.0.1.123.
  • host name or IP address of the central manager: specified from a managed unit to execute on the central manager. For example, api_target_host=10.0.1.123.

IP addresses must conform to the IP mode of your network. For dual IP mode, use the same IP protocol with which the managed unit is registered with the central manager. For example, if the registration uses IPv6, specify an IPv6 address. The hostname is independent of IP mode and can be used with any mode.