CreateSqlCollectionDetails

class oci.data_safe.models.CreateSqlCollectionDetails(**kwargs)

Bases: object

Details for SQL collection creation.

Attributes:

SQL_LEVEL_ALL_SQL

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

SQL_LEVEL_USER_ISSUED_SQL

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

STATUS_DISABLED

A constant which can be used with the status property of a CreateSqlCollectionDetails.

STATUS_ENABLED

A constant which can be used with the status property of a CreateSqlCollectionDetails.

compartment_id

[Required] Gets the compartment_id of this CreateSqlCollectionDetails.

db_user_name

[Required] Gets the db_user_name of this CreateSqlCollectionDetails.

defined_tags

Gets the defined_tags of this CreateSqlCollectionDetails.

description

Gets the description of this CreateSqlCollectionDetails.

display_name

Gets the display_name of this CreateSqlCollectionDetails.

freeform_tags

Gets the freeform_tags of this CreateSqlCollectionDetails.

sql_level

Gets the sql_level of this CreateSqlCollectionDetails.

status

Gets the status of this CreateSqlCollectionDetails.

target_id

[Required] Gets the target_id of this CreateSqlCollectionDetails.

Methods:

__init__(**kwargs)

Initializes a new CreateSqlCollectionDetails 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 CreateSqlCollectionDetails. 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 CreateSqlCollectionDetails. This constant has a value of “USER_ISSUED_SQL”

STATUS_DISABLED = 'DISABLED'

A constant which can be used with the status property of a CreateSqlCollectionDetails. This constant has a value of “DISABLED”

STATUS_ENABLED = 'ENABLED'

A constant which can be used with the status property of a CreateSqlCollectionDetails. This constant has a value of “ENABLED”

__init__(**kwargs)

Initializes a new CreateSqlCollectionDetails object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • display_name (str) – The value to assign to the display_name property of this CreateSqlCollectionDetails.

  • description (str) – The value to assign to the description property of this CreateSqlCollectionDetails.

  • compartment_id (str) – The value to assign to the compartment_id property of this CreateSqlCollectionDetails.

  • target_id (str) – The value to assign to the target_id property of this CreateSqlCollectionDetails.

  • status (str) – The value to assign to the status property of this CreateSqlCollectionDetails. Allowed values for this property are: “ENABLED”, “DISABLED”

  • db_user_name (str) – The value to assign to the db_user_name property of this CreateSqlCollectionDetails.

  • sql_level (str) – The value to assign to the sql_level property of this CreateSqlCollectionDetails. Allowed values for this property are: “USER_ISSUED_SQL”, “ALL_SQL”

  • freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this CreateSqlCollectionDetails.

  • defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this CreateSqlCollectionDetails.

property compartment_id

[Required] Gets the compartment_id of this CreateSqlCollectionDetails. The OCID of the compartment containing the SQL collection.

Returns

The compartment_id of this CreateSqlCollectionDetails.

Return type

str

property db_user_name

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

Returns

The db_user_name of this CreateSqlCollectionDetails.

Return type

str

property defined_tags

Gets the defined_tags of this CreateSqlCollectionDetails. 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 CreateSqlCollectionDetails.

Return type

dict(str, dict(str, object))

property description

Gets the description of this CreateSqlCollectionDetails. The description of the SQL collection.

Returns

The description of this CreateSqlCollectionDetails.

Return type

str

property display_name

Gets the display_name of this CreateSqlCollectionDetails. The display name of the SQL collection. The name does not have to be unique, and it is changeable.

Returns

The display_name of this CreateSqlCollectionDetails.

Return type

str

property freeform_tags

Gets the freeform_tags of this CreateSqlCollectionDetails. 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 CreateSqlCollectionDetails.

Return type

dict(str, str)

property sql_level

Gets the sql_level of this CreateSqlCollectionDetails. Specifies the level of SQL that will be collected. 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”

Returns

The sql_level of this CreateSqlCollectionDetails.

Return type

str

property status

Gets the status of this CreateSqlCollectionDetails. Specifies if the SqlCollection has to be started after creation. Enabled indicates that the SqlCollection will be started after creation.

Allowed values for this property are: “ENABLED”, “DISABLED”

Returns

The status of this CreateSqlCollectionDetails.

Return type

str

property target_id

[Required] Gets the target_id of this CreateSqlCollectionDetails. The OCID of the target corresponding to the security policy deployment.

Returns

The target_id of this CreateSqlCollectionDetails.

Return type

str