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’.

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

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

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

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

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

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

id¶

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

Returns:	The id of this SqlFirewallViolationSummary.
Return type:	str

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

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

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

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

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

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

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

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

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

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