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.

property 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

property 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

property 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

property 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))

property description

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

Returns

The description of this SqlFirewallAllowedSql.

Return type

str

property 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

property 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)

property 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

property 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

property 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]

property 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

property 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

property 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

property 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))

property 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

property 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

property 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