SqlFirewallViolationAggregationDimensions

class oci.data_safe.models.SqlFirewallViolationAggregationDimensions(**kwargs)

Bases: object

The details of the aggregation dimensions used for summarizing SQL violations.

Attributes:

SQL_LEVEL_ALL_SQL

A constant which can be used with the sql_level property of a SqlFirewallViolationAggregationDimensions.

SQL_LEVEL_USER_ISSUED_SQL

A constant which can be used with the sql_level property of a SqlFirewallViolationAggregationDimensions.

client_ip

Gets the client_ip of this SqlFirewallViolationAggregationDimensions.

client_os_user_name

Gets the client_os_user_name of this SqlFirewallViolationAggregationDimensions.

client_program

Gets the client_program of this SqlFirewallViolationAggregationDimensions.

db_user_name

Gets the db_user_name of this SqlFirewallViolationAggregationDimensions.

operation

Gets the operation of this SqlFirewallViolationAggregationDimensions.

operation_time

Gets the operation_time of this SqlFirewallViolationAggregationDimensions.

sql_level

Gets the sql_level of this SqlFirewallViolationAggregationDimensions.

target_id

Gets the target_id of this SqlFirewallViolationAggregationDimensions.

target_name

Gets the target_name of this SqlFirewallViolationAggregationDimensions.

violation_action

Gets the violation_action of this SqlFirewallViolationAggregationDimensions.

violation_cause

Gets the violation_cause of this SqlFirewallViolationAggregationDimensions.

Methods:

__init__(**kwargs)

Initializes a new SqlFirewallViolationAggregationDimensions object with values from keyword arguments.

SQL_LEVEL_ALL_SQL = 'ALL_SQL'

A constant which can be used with the sql_level property of a SqlFirewallViolationAggregationDimensions. This constant has a value of “ALL_SQL”

SQL_LEVEL_USER_ISSUED_SQL = 'USER_ISSUED_SQL'

A constant which can be used with the sql_level property of a SqlFirewallViolationAggregationDimensions. This constant has a value of “USER_ISSUED_SQL”

__init__(**kwargs)

Initializes a new SqlFirewallViolationAggregationDimensions object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • operation_time (list[datetime]) – The value to assign to the operation_time property of this SqlFirewallViolationAggregationDimensions.

  • db_user_name (list[str]) – The value to assign to the db_user_name property of this SqlFirewallViolationAggregationDimensions.

  • target_id (list[str]) – The value to assign to the target_id property of this SqlFirewallViolationAggregationDimensions.

  • target_name (list[str]) – The value to assign to the target_name property of this SqlFirewallViolationAggregationDimensions.

  • client_program (list[str]) – The value to assign to the client_program property of this SqlFirewallViolationAggregationDimensions.

  • operation (list[str]) – The value to assign to the operation property of this SqlFirewallViolationAggregationDimensions.

  • client_os_user_name (list[str]) – The value to assign to the client_os_user_name property of this SqlFirewallViolationAggregationDimensions.

  • violation_cause (list[str]) – The value to assign to the violation_cause property of this SqlFirewallViolationAggregationDimensions.

  • client_ip (list[str]) – The value to assign to the client_ip property of this SqlFirewallViolationAggregationDimensions.

  • violation_action (list[str]) – The value to assign to the violation_action property of this SqlFirewallViolationAggregationDimensions.

  • sql_level (list[str]) – The value to assign to the sql_level property of this SqlFirewallViolationAggregationDimensions. Allowed values for items in this list are: “USER_ISSUED_SQL”, “ALL_SQL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

property client_ip

Gets the client_ip of this SqlFirewallViolationAggregationDimensions. The IP address of the host from which the session was spawned.

Returns

The client_ip of this SqlFirewallViolationAggregationDimensions.

Return type

list[str]

property client_os_user_name

Gets the client_os_user_name of this SqlFirewallViolationAggregationDimensions. The name of the operating system user for the database session.

Returns

The client_os_user_name of this SqlFirewallViolationAggregationDimensions.

Return type

list[str]

property client_program

Gets the client_program of this SqlFirewallViolationAggregationDimensions. The application from which the SQL violation was generated. Examples SQL Plus or SQL Developer.

Returns

The client_program of this SqlFirewallViolationAggregationDimensions.

Return type

list[str]

property db_user_name

Gets the db_user_name of this SqlFirewallViolationAggregationDimensions. The name of the database user.

Returns

The db_user_name of this SqlFirewallViolationAggregationDimensions.

Return type

list[str]

property operation

Gets the operation of this SqlFirewallViolationAggregationDimensions. The name of the action executed by the user on the target database, for example, ALTER, CREATE, DROP.

Returns

The operation of this SqlFirewallViolationAggregationDimensions.

Return type

list[str]

property operation_time

Gets the operation_time of this SqlFirewallViolationAggregationDimensions. The time of the SQL violation occurrence in the target database.

Returns

The operation_time of this SqlFirewallViolationAggregationDimensions.

Return type

list[datetime]

property sql_level

Gets the sql_level of this SqlFirewallViolationAggregationDimensions. Specifies the level of SQL included for this SQL Firewall policy. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.

Allowed values for items in this list are: “USER_ISSUED_SQL”, “ALL_SQL”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The sql_level of this SqlFirewallViolationAggregationDimensions.

Return type

list[str]

property target_id

Gets the target_id of this SqlFirewallViolationAggregationDimensions. The OCID of the target database.

Returns

The target_id of this SqlFirewallViolationAggregationDimensions.

Return type

list[str]

property target_name

Gets the target_name of this SqlFirewallViolationAggregationDimensions. The name of the target database.

Returns

The target_name of this SqlFirewallViolationAggregationDimensions.

Return type

list[str]

property violation_action

Gets the violation_action of this SqlFirewallViolationAggregationDimensions. The action taken for this SQL violation.

Returns

The violation_action of this SqlFirewallViolationAggregationDimensions.

Return type

list[str]

property violation_cause

Gets the violation_cause of this SqlFirewallViolationAggregationDimensions. Indicates whether SQL or context violation.

Returns

The violation_cause of this SqlFirewallViolationAggregationDimensions.

Return type

list[str]