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

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]