SqlFirewallAllowedSql¶

class oci.data_safe.models.SqlFirewallAllowedSql(**kwargs)¶

Bases: object

The resource represents a SQL Firewall allowed SQL in Data Safe.

Attributes

`LIFECYCLE_STATE_ACTIVE`	A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSql.
`LIFECYCLE_STATE_DELETED`	A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSql.
`LIFECYCLE_STATE_FAILED`	A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSql.
`SQL_LEVEL_ALL_SQL`	A constant which can be used with the sql_level property of a SqlFirewallAllowedSql.
`SQL_LEVEL_USER_ISSUED_SQL`	A constant which can be used with the sql_level property of a SqlFirewallAllowedSql.
`compartment_id`	[Required] Gets the compartment_id of this SqlFirewallAllowedSql.
`current_user`	Gets the current_user of this SqlFirewallAllowedSql.
`db_user_name`	[Required] Gets the db_user_name of this SqlFirewallAllowedSql.
`defined_tags`	Gets the defined_tags of this SqlFirewallAllowedSql.
`description`	Gets the description of this SqlFirewallAllowedSql.
`display_name`	[Required] Gets the display_name of this SqlFirewallAllowedSql.
`freeform_tags`	Gets the freeform_tags of this SqlFirewallAllowedSql.
`id`	[Required] Gets the id of this SqlFirewallAllowedSql.
`lifecycle_state`	[Required] Gets the lifecycle_state of this SqlFirewallAllowedSql.
`sql_accessed_objects`	Gets the sql_accessed_objects of this SqlFirewallAllowedSql.
`sql_firewall_policy_id`	[Required] Gets the sql_firewall_policy_id of this SqlFirewallAllowedSql.
`sql_level`	[Required] Gets the sql_level of this SqlFirewallAllowedSql.
`sql_text`	[Required] Gets the sql_text of this SqlFirewallAllowedSql.
`system_tags`	Gets the system_tags of this SqlFirewallAllowedSql.
`time_collected`	[Required] Gets the time_collected of this SqlFirewallAllowedSql.
`time_updated`	Gets the time_updated of this SqlFirewallAllowedSql.
`version`	[Required] Gets the version of this SqlFirewallAllowedSql.

Methods

__init__(**kwargs) Initializes a new SqlFirewallAllowedSql object with values from keyword arguments.

LIFECYCLE_STATE_ACTIVE = 'ACTIVE'¶: A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSql. This constant has a value of “ACTIVE”

LIFECYCLE_STATE_DELETED = 'DELETED'¶: A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSql. This constant has a value of “DELETED”

LIFECYCLE_STATE_FAILED = 'FAILED'¶: A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSql. This constant has a value of “FAILED”

SQL_LEVEL_ALL_SQL = 'ALL_SQL'¶: A constant which can be used with the sql_level property of a SqlFirewallAllowedSql. 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 SqlFirewallAllowedSql. This constant has a value of “USER_ISSUED_SQL”

__init__(**kwargs)¶

Initializes a new SqlFirewallAllowedSql 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 SqlFirewallAllowedSql.
compartment_id (str) – The value to assign to the compartment_id property of this SqlFirewallAllowedSql.
display_name (str) – The value to assign to the display_name property of this SqlFirewallAllowedSql.
description (str) – The value to assign to the description property of this SqlFirewallAllowedSql.
sql_firewall_policy_id (str) – The value to assign to the sql_firewall_policy_id property of this SqlFirewallAllowedSql.
current_user (str) – The value to assign to the current_user property of this SqlFirewallAllowedSql.
db_user_name (str) – The value to assign to the db_user_name property of this SqlFirewallAllowedSql.
sql_text (str) – The value to assign to the sql_text property of this SqlFirewallAllowedSql.
sql_level (str) – The value to assign to the sql_level property of this SqlFirewallAllowedSql. 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’.
sql_accessed_objects (list[str]) – The value to assign to the sql_accessed_objects property of this SqlFirewallAllowedSql.
version (float) – The value to assign to the version property of this SqlFirewallAllowedSql.
time_collected (datetime) – The value to assign to the time_collected property of this SqlFirewallAllowedSql.
time_updated (datetime) – The value to assign to the time_updated property of this SqlFirewallAllowedSql.
lifecycle_state (str) – The value to assign to the lifecycle_state property of this SqlFirewallAllowedSql. Allowed values for this property are: “ACTIVE”, “DELETED”, “FAILED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this SqlFirewallAllowedSql.
defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this SqlFirewallAllowedSql.
system_tags (dict(str, dict(str, object))) – The value to assign to the system_tags property of this SqlFirewallAllowedSql.

compartment_id¶

[Required] Gets the compartment_id of this SqlFirewallAllowedSql. The OCID of the compartment containing the SQL Firewall allowed SQL.

Returns:	The compartment_id of this SqlFirewallAllowedSql.
Return type:	str

current_user¶

Gets the current_user of this SqlFirewallAllowedSql. The name of the user that SQL was executed as.

Returns:	The current_user of this SqlFirewallAllowedSql.
Return type:	str

db_user_name¶

[Required] Gets the db_user_name of this SqlFirewallAllowedSql. The database user name.

Returns:	The db_user_name of this SqlFirewallAllowedSql.
Return type:	str

defined_tags¶

Gets the defined_tags of this SqlFirewallAllowedSql. Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags

Example: {“Operations”: {“CostCenter”: “42”}}

Returns:	The defined_tags of this SqlFirewallAllowedSql.
Return type:	dict(str, dict(str, object))

description¶

Gets the description of this SqlFirewallAllowedSql. The description of the SQL Firewall allowed SQL.

Returns:	The description of this SqlFirewallAllowedSql.
Return type:	str

display_name¶

[Required] Gets the display_name of this SqlFirewallAllowedSql. The display name of the SQL Firewall allowed SQL.

Returns:	The display_name of this SqlFirewallAllowedSql.
Return type:	str

freeform_tags¶

Gets the freeform_tags of this SqlFirewallAllowedSql. Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags

Example: {“Department”: “Finance”}

Returns:	The freeform_tags of this SqlFirewallAllowedSql.
Return type:	dict(str, str)

id¶

[Required] Gets the id of this SqlFirewallAllowedSql. The OCID of the SQL Firewall allowed SQL.

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

lifecycle_state¶

[Required] Gets the lifecycle_state of this SqlFirewallAllowedSql. The current state of the SQL Firewall allowed SQL.

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

Returns:	The lifecycle_state of this SqlFirewallAllowedSql.
Return type:	str

sql_accessed_objects¶

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

Returns:	The sql_accessed_objects of this SqlFirewallAllowedSql.
Return type:	list[str]

sql_firewall_policy_id¶

[Required] Gets the sql_firewall_policy_id of this SqlFirewallAllowedSql. The OCID of the SQL Firewall policy corresponding to the SQL Firewall allowed SQL.

Returns:	The sql_firewall_policy_id of this SqlFirewallAllowedSql.
Return type:	str

sql_level¶

[Required] Gets the sql_level of this SqlFirewallAllowedSql. 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 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 SqlFirewallAllowedSql.
Return type:	str

sql_text¶

[Required] Gets the sql_text of this SqlFirewallAllowedSql. The SQL text of the SQL Firewall allowed SQL.

Returns:	The sql_text of this SqlFirewallAllowedSql.
Return type:	str

system_tags¶

Gets the system_tags of this SqlFirewallAllowedSql. System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {“orcl-cloud”: {“free-tier-retained”: “true”}}

Returns:	The system_tags of this SqlFirewallAllowedSql.
Return type:	dict(str, dict(str, object))

time_collected¶

[Required] Gets the time_collected of this SqlFirewallAllowedSql. The time the the SQL Firewall allowed SQL was collected from the target database, in the format defined by RFC3339.

Returns:	The time_collected of this SqlFirewallAllowedSql.
Return type:	datetime

time_updated¶

Gets the time_updated of this SqlFirewallAllowedSql. The last date and time the SQL Firewall allowed SQL was updated, in the format defined by RFC3339.

Returns:	The time_updated of this SqlFirewallAllowedSql.
Return type:	datetime

version¶

[Required] Gets the version of this SqlFirewallAllowedSql. Version of the associated SQL Firewall policy. This identifies whether the allowed SQLs were added in the same batch or not.

Returns:	The version of this SqlFirewallAllowedSql.
Return type:	float