SqlFirewallViolationSummary¶
- class oci.data_safe.models.SqlFirewallViolationSummary(**kwargs)¶
Bases:
objectThe resource represents the SQL violations collected from the target database by Oracle Data Safe.
Attributes:
A constant which can be used with the sql_level property of a SqlFirewallViolationSummary.
A constant which can be used with the sql_level property of a SqlFirewallViolationSummary.
A constant which can be used with the violation_action property of a SqlFirewallViolationSummary.
A constant which can be used with the violation_action property of a SqlFirewallViolationSummary.
Gets the client_ip of this SqlFirewallViolationSummary.
Gets the client_os_user_name of this SqlFirewallViolationSummary.
Gets the client_program of this SqlFirewallViolationSummary.
[Required] Gets the compartment_id of this SqlFirewallViolationSummary.
Gets the current_db_user_name of this SqlFirewallViolationSummary.
Gets the db_user_name of this SqlFirewallViolationSummary.
[Required] Gets the id of this SqlFirewallViolationSummary.
Gets the operation of this SqlFirewallViolationSummary.
[Required] Gets the operation_time of this SqlFirewallViolationSummary.
Gets the sql_accessed_objects of this SqlFirewallViolationSummary.
Gets the sql_level of this SqlFirewallViolationSummary.
Gets the sql_text of this SqlFirewallViolationSummary.
[Required] Gets the target_id of this SqlFirewallViolationSummary.
[Required] Gets the target_name of this SqlFirewallViolationSummary.
[Required] Gets the time_collected of this SqlFirewallViolationSummary.
[Required] Gets the violation_action of this SqlFirewallViolationSummary.
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