SqlFirewallAllowedSqlSummary¶
- class oci.data_safe.models.SqlFirewallAllowedSqlSummary(**kwargs)¶
Bases:
objectThe resource represents a SQL Firewall allowed SQL in Data Safe.
Attributes:
A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSqlSummary.
A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSqlSummary.
A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSqlSummary.
A constant which can be used with the sql_level property of a SqlFirewallAllowedSqlSummary.
A constant which can be used with the sql_level property of a SqlFirewallAllowedSqlSummary.
[Required] Gets the compartment_id of this SqlFirewallAllowedSqlSummary.
Gets the current_user of this SqlFirewallAllowedSqlSummary.
[Required] Gets the db_user_name of this SqlFirewallAllowedSqlSummary.
Gets the defined_tags of this SqlFirewallAllowedSqlSummary.
Gets the description of this SqlFirewallAllowedSqlSummary.
[Required] Gets the display_name of this SqlFirewallAllowedSqlSummary.
Gets the freeform_tags of this SqlFirewallAllowedSqlSummary.
[Required] Gets the id of this SqlFirewallAllowedSqlSummary.
[Required] Gets the lifecycle_state of this SqlFirewallAllowedSqlSummary.
Gets the sql_accessed_objects of this SqlFirewallAllowedSqlSummary.
[Required] Gets the sql_firewall_policy_id of this SqlFirewallAllowedSqlSummary.
[Required] Gets the sql_level of this SqlFirewallAllowedSqlSummary.
[Required] Gets the sql_text of this SqlFirewallAllowedSqlSummary.
Gets the system_tags of this SqlFirewallAllowedSqlSummary.
[Required] Gets the time_collected of this SqlFirewallAllowedSqlSummary.
Gets the time_updated of this SqlFirewallAllowedSqlSummary.
[Required] Gets the version of this SqlFirewallAllowedSqlSummary.
Methods:
__init__(**kwargs)Initializes a new SqlFirewallAllowedSqlSummary object with values from keyword arguments.
- LIFECYCLE_STATE_ACTIVE = 'ACTIVE'¶
A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSqlSummary. This constant has a value of “ACTIVE”
- LIFECYCLE_STATE_DELETED = 'DELETED'¶
A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSqlSummary. This constant has a value of “DELETED”
- LIFECYCLE_STATE_FAILED = 'FAILED'¶
A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSqlSummary. 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 SqlFirewallAllowedSqlSummary. 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 SqlFirewallAllowedSqlSummary. This constant has a value of “USER_ISSUED_SQL”
- __init__(**kwargs)¶
Initializes a new SqlFirewallAllowedSqlSummary 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 SqlFirewallAllowedSqlSummary.
compartment_id (str) – The value to assign to the compartment_id property of this SqlFirewallAllowedSqlSummary.
display_name (str) – The value to assign to the display_name property of this SqlFirewallAllowedSqlSummary.
description (str) – The value to assign to the description property of this SqlFirewallAllowedSqlSummary.
sql_firewall_policy_id (str) – The value to assign to the sql_firewall_policy_id property of this SqlFirewallAllowedSqlSummary.
current_user (str) – The value to assign to the current_user property of this SqlFirewallAllowedSqlSummary.
db_user_name (str) – The value to assign to the db_user_name property of this SqlFirewallAllowedSqlSummary.
sql_text (str) – The value to assign to the sql_text property of this SqlFirewallAllowedSqlSummary.
sql_level (str) – The value to assign to the sql_level property of this SqlFirewallAllowedSqlSummary. 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 SqlFirewallAllowedSqlSummary.
version (float) – The value to assign to the version property of this SqlFirewallAllowedSqlSummary.
time_collected (datetime) – The value to assign to the time_collected property of this SqlFirewallAllowedSqlSummary.
time_updated (datetime) – The value to assign to the time_updated property of this SqlFirewallAllowedSqlSummary.
lifecycle_state (str) – The value to assign to the lifecycle_state property of this SqlFirewallAllowedSqlSummary. 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 SqlFirewallAllowedSqlSummary.
defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this SqlFirewallAllowedSqlSummary.
system_tags (dict(str, dict(str, object))) – The value to assign to the system_tags property of this SqlFirewallAllowedSqlSummary.
- property compartment_id¶
[Required] Gets the compartment_id of this SqlFirewallAllowedSqlSummary. The OCID of the compartment containing the SQL Firewall allowed SQL.
- Returns
The compartment_id of this SqlFirewallAllowedSqlSummary.
- Return type
str
- property current_user¶
Gets the current_user of this SqlFirewallAllowedSqlSummary. The name of the user that SQL was executed as.
- Returns
The current_user of this SqlFirewallAllowedSqlSummary.
- Return type
str
- property db_user_name¶
[Required] Gets the db_user_name of this SqlFirewallAllowedSqlSummary. The database user name.
- Returns
The db_user_name of this SqlFirewallAllowedSqlSummary.
- Return type
str
- property defined_tags¶
Gets the defined_tags of this SqlFirewallAllowedSqlSummary. 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 SqlFirewallAllowedSqlSummary.
- Return type
dict(str, dict(str, object))
- property description¶
Gets the description of this SqlFirewallAllowedSqlSummary. The description of the SQL Firewall allowed SQL.
- Returns
The description of this SqlFirewallAllowedSqlSummary.
- Return type
str
- property display_name¶
[Required] Gets the display_name of this SqlFirewallAllowedSqlSummary. The display name of the SQL Firewall allowed SQL.
- Returns
The display_name of this SqlFirewallAllowedSqlSummary.
- Return type
str
- property freeform_tags¶
Gets the freeform_tags of this SqlFirewallAllowedSqlSummary. 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 SqlFirewallAllowedSqlSummary.
- Return type
dict(str, str)
- property id¶
[Required] Gets the id of this SqlFirewallAllowedSqlSummary. The OCID of the SQL Firewall allowed SQL.
- Returns
The id of this SqlFirewallAllowedSqlSummary.
- Return type
str
- property lifecycle_state¶
[Required] Gets the lifecycle_state of this SqlFirewallAllowedSqlSummary. 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 SqlFirewallAllowedSqlSummary.
- Return type
str
- property sql_accessed_objects¶
Gets the sql_accessed_objects of this SqlFirewallAllowedSqlSummary. The objects accessed by the SQL.
- Returns
The sql_accessed_objects of this SqlFirewallAllowedSqlSummary.
- Return type
list[str]
- property sql_firewall_policy_id¶
[Required] Gets the sql_firewall_policy_id of this SqlFirewallAllowedSqlSummary. The OCID of the SQL Firewall policy corresponding to the SQL Firewall allowed SQL.
- Returns
The sql_firewall_policy_id of this SqlFirewallAllowedSqlSummary.
- Return type
str
- property sql_level¶
[Required] Gets the sql_level of this SqlFirewallAllowedSqlSummary. 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 SqlFirewallAllowedSqlSummary.
- Return type
str
- property sql_text¶
[Required] Gets the sql_text of this SqlFirewallAllowedSqlSummary. The SQL text of the SQL Firewall allowed SQL.
- Returns
The sql_text of this SqlFirewallAllowedSqlSummary.
- Return type
str
- property system_tags¶
Gets the system_tags of this SqlFirewallAllowedSqlSummary. 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 SqlFirewallAllowedSqlSummary.
- Return type
dict(str, dict(str, object))
- property time_collected¶
[Required] Gets the time_collected of this SqlFirewallAllowedSqlSummary. 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 SqlFirewallAllowedSqlSummary.
- Return type
datetime
- property time_updated¶
Gets the time_updated of this SqlFirewallAllowedSqlSummary. The last date and time the SQL Firewall allowed SQL was updated, in the format defined by RFC3339.
- Returns
The time_updated of this SqlFirewallAllowedSqlSummary.
- Return type
datetime
- property version¶
[Required] Gets the version of this SqlFirewallAllowedSqlSummary. 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 SqlFirewallAllowedSqlSummary.
- Return type
float