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.
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
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
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))
description

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

Returns:The description of this CreateSqlCollectionDetails.
Return type:str
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
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)
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
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
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