Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace SqlFirewallViolationSummary

The resource represents the SQL violations collected from the target database by Oracle Data Safe.

Properties

Optional clientIp

clientIp: undefined | string

The IP address of the host machine from which the session was generated.

Optional clientOsUserName

clientOsUserName: undefined | string

The name of the operating system user for the database session.

Optional clientProgram

clientProgram: undefined | string

The application from which the SQL violation was generated. Examples include SQL Plus or SQL Developer.

compartmentId

compartmentId: string

The OCID of the compartment containing the SQL violation.

Optional currentDbUserName

currentDbUserName: undefined | string

The name of the user that SQL was executed as.

Optional dbUserName

dbUserName: undefined | string

The name of the database user.

id

id: string

The OCID of the SQL violation.

Optional operation

operation: undefined | string

The name of the action executed by the user on the target database. For example, ALTER, CREATE, DROP.

operationTime

operationTime: Date

The time of the SQL violation occurrence in the target database.

Optional sqlAccessedObjects

sqlAccessedObjects: undefined | string

The objects accessed by the SQL.

Optional sqlLevel

sqlLevel: SqlLevel

Specifies the level of SQL for this violation. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.

Optional sqlText

sqlText: undefined | string

The SQL text caught by the firewall.

targetId

targetId: string

The OCID of the target database.

targetName

targetName: string

The name of the target database.

timeCollected

timeCollected: Date

The timestamp when this SQL violation was collected from the target database by Data Safe.

violationAction

violationAction: ViolationAction

The action taken for this SQL violation.

Optional violationCause

violationCause: undefined | string

Indicates whether SQL or context violation.

Functions

getDeserializedJsonObj

getJsonObj