SqlFirewallViolationSummary

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

Bases: object

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

Attributes:

SQL_LEVEL_ALL_SQL

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

SQL_LEVEL_USER_ISSUED_SQL

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

VIOLATION_ACTION_ALLOWED

A constant which can be used with the violation_action property of a SqlFirewallViolationSummary.

VIOLATION_ACTION_BLOCKED

A constant which can be used with the violation_action property of a SqlFirewallViolationSummary.

client_ip

Gets the client_ip of this SqlFirewallViolationSummary.

client_os_user_name

Gets the client_os_user_name of this SqlFirewallViolationSummary.

client_program

Gets the client_program of this SqlFirewallViolationSummary.

compartment_id

[Required] Gets the compartment_id of this SqlFirewallViolationSummary.

current_db_user_name

Gets the current_db_user_name of this SqlFirewallViolationSummary.

db_user_name

Gets the db_user_name of this SqlFirewallViolationSummary.

id

[Required] Gets the id of this SqlFirewallViolationSummary.

operation

Gets the operation of this SqlFirewallViolationSummary.

operation_time

[Required] Gets the operation_time of this SqlFirewallViolationSummary.

sql_accessed_objects

Gets the sql_accessed_objects of this SqlFirewallViolationSummary.

sql_level

Gets the sql_level of this SqlFirewallViolationSummary.

sql_text

Gets the sql_text of this SqlFirewallViolationSummary.

target_id

[Required] Gets the target_id of this SqlFirewallViolationSummary.

target_name

[Required] Gets the target_name of this SqlFirewallViolationSummary.

time_collected

[Required] Gets the time_collected of this SqlFirewallViolationSummary.

violation_action

[Required] Gets the violation_action of this SqlFirewallViolationSummary.

violation_cause

Gets the violation_cause of this SqlFirewallViolationSummary.

Methods:

__init__(**kwargs)

Initializes a new SqlFirewallViolationSummary 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 SqlFirewallViolationSummary. 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 SqlFirewallViolationSummary. This constant has a value of “USER_ISSUED_SQL”

VIOLATION_ACTION_ALLOWED = 'ALLOWED'

A constant which can be used with the violation_action property of a SqlFirewallViolationSummary. This constant has a value of “ALLOWED”

VIOLATION_ACTION_BLOCKED = 'BLOCKED'

A constant which can be used with the violation_action property of a SqlFirewallViolationSummary. This constant has a value of “BLOCKED”

__init__(**kwargs)

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

Parameters
  • id (str) – The value to assign to the id property of this SqlFirewallViolationSummary.

  • compartment_id (str) – The value to assign to the compartment_id property of this SqlFirewallViolationSummary.

  • db_user_name (str) – The value to assign to the db_user_name property of this SqlFirewallViolationSummary.

  • target_id (str) – The value to assign to the target_id property of this SqlFirewallViolationSummary.

  • target_name (str) – The value to assign to the target_name property of this SqlFirewallViolationSummary.

  • operation_time (datetime) – The value to assign to the operation_time property of this SqlFirewallViolationSummary.

  • time_collected (datetime) – The value to assign to the time_collected property of this SqlFirewallViolationSummary.

  • client_os_user_name (str) – The value to assign to the client_os_user_name property of this SqlFirewallViolationSummary.

  • operation (str) – The value to assign to the operation property of this SqlFirewallViolationSummary.

  • sql_text (str) – The value to assign to the sql_text property of this SqlFirewallViolationSummary.

  • sql_accessed_objects (str) – The value to assign to the sql_accessed_objects property of this SqlFirewallViolationSummary.

  • current_db_user_name (str) – The value to assign to the current_db_user_name property of this SqlFirewallViolationSummary.

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

  • client_ip (str) – The value to assign to the client_ip property of this SqlFirewallViolationSummary.

  • client_program (str) – The value to assign to the client_program property of this SqlFirewallViolationSummary.

  • violation_cause (str) – The value to assign to the violation_cause property of this SqlFirewallViolationSummary.

  • violation_action (str) – The value to assign to the violation_action property of this SqlFirewallViolationSummary. Allowed values for this property are: “BLOCKED”, “ALLOWED”, ‘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 SqlFirewallViolationSummary. The IP address of the host machine from which the session was generated.

Returns

The client_ip of this SqlFirewallViolationSummary.

Return type

str

property client_os_user_name

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

Returns

The client_os_user_name of this SqlFirewallViolationSummary.

Return type

str

property client_program

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

Returns

The client_program of this SqlFirewallViolationSummary.

Return type

str

property compartment_id

[Required] Gets the compartment_id of this SqlFirewallViolationSummary. The OCID of the compartment containing the SQL violation.

Returns

The compartment_id of this SqlFirewallViolationSummary.

Return type

str

property current_db_user_name

Gets the current_db_user_name of this SqlFirewallViolationSummary. The name of the user that SQL was executed as.

Returns

The current_db_user_name of this SqlFirewallViolationSummary.

Return type

str

property db_user_name

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

Returns

The db_user_name of this SqlFirewallViolationSummary.

Return type

str

property id

[Required] Gets the id of this SqlFirewallViolationSummary. The OCID of the SQL violation.

Returns

The id of this SqlFirewallViolationSummary.

Return type

str

property operation

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

Returns

The operation of this SqlFirewallViolationSummary.

Return type

str

property operation_time

[Required] Gets the operation_time of this SqlFirewallViolationSummary. The time of the SQL violation occurrence in the target database.

Returns

The operation_time of this SqlFirewallViolationSummary.

Return type

datetime

property sql_accessed_objects

Gets the sql_accessed_objects of this SqlFirewallViolationSummary. The objects accessed by the SQL.

Returns

The sql_accessed_objects of this SqlFirewallViolationSummary.

Return type

str

property sql_level

Gets the sql_level of this SqlFirewallViolationSummary. 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.

Allowed values for this property 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 SqlFirewallViolationSummary.

Return type

str

property sql_text

Gets the sql_text of this SqlFirewallViolationSummary. The SQL text caught by the firewall.

Returns

The sql_text of this SqlFirewallViolationSummary.

Return type

str

property target_id

[Required] Gets the target_id of this SqlFirewallViolationSummary. The OCID of the target database.

Returns

The target_id of this SqlFirewallViolationSummary.

Return type

str

property target_name

[Required] Gets the target_name of this SqlFirewallViolationSummary. The name of the target database.

Returns

The target_name of this SqlFirewallViolationSummary.

Return type

str

property time_collected

[Required] Gets the time_collected of this SqlFirewallViolationSummary. The timestamp when this SQL violation was collected from the target database by Data Safe.

Returns

The time_collected of this SqlFirewallViolationSummary.

Return type

datetime

property violation_action

[Required] Gets the violation_action of this SqlFirewallViolationSummary. The action taken for this SQL violation.

Allowed values for this property are: “BLOCKED”, “ALLOWED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The violation_action of this SqlFirewallViolationSummary.

Return type

str

property violation_cause

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

Returns

The violation_cause of this SqlFirewallViolationSummary.

Return type

str