SqlFirewallAllowedSqlSummary

class oci.data_safe.models.SqlFirewallAllowedSqlSummary(**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 SqlFirewallAllowedSqlSummary.

LIFECYCLE_STATE_DELETED

A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSqlSummary.

LIFECYCLE_STATE_FAILED

A constant which can be used with the lifecycle_state property of a SqlFirewallAllowedSqlSummary.

SQL_LEVEL_ALL_SQL

A constant which can be used with the sql_level property of a SqlFirewallAllowedSqlSummary.

SQL_LEVEL_USER_ISSUED_SQL

A constant which can be used with the sql_level property of a SqlFirewallAllowedSqlSummary.

compartment_id

[Required] Gets the compartment_id of this SqlFirewallAllowedSqlSummary.

current_user

Gets the current_user of this SqlFirewallAllowedSqlSummary.

db_user_name

[Required] Gets the db_user_name of this SqlFirewallAllowedSqlSummary.

defined_tags

Gets the defined_tags of this SqlFirewallAllowedSqlSummary.

description

Gets the description of this SqlFirewallAllowedSqlSummary.

display_name

[Required] Gets the display_name of this SqlFirewallAllowedSqlSummary.

freeform_tags

Gets the freeform_tags of this SqlFirewallAllowedSqlSummary.

id

[Required] Gets the id of this SqlFirewallAllowedSqlSummary.

lifecycle_state

[Required] Gets the lifecycle_state of this SqlFirewallAllowedSqlSummary.

sql_accessed_objects

Gets the sql_accessed_objects of this SqlFirewallAllowedSqlSummary.

sql_firewall_policy_id

[Required] Gets the sql_firewall_policy_id of this SqlFirewallAllowedSqlSummary.

sql_level

[Required] Gets the sql_level of this SqlFirewallAllowedSqlSummary.

sql_text

[Required] Gets the sql_text of this SqlFirewallAllowedSqlSummary.

system_tags

Gets the system_tags of this SqlFirewallAllowedSqlSummary.

time_collected

[Required] Gets the time_collected of this SqlFirewallAllowedSqlSummary.

time_updated

Gets the time_updated of this SqlFirewallAllowedSqlSummary.

version

[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