Class SqlCollection

The resource represents SQL collection for a specific database user in a target. SqlCollection encapsulates the SQL commands issued in the user\u2019s database sessions, and its execution context.

Inheritance

object

SqlCollection

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatasafeService.Models

Assembly: OCI.DotNetSDK.Datasafe.dll

Syntax

public class SqlCollection

Properties

CompartmentId

Declaration

[Required(ErrorMessage = "CompartmentId is required.")]
[JsonProperty(PropertyName = "compartmentId")]
public string CompartmentId { get; set; }

Property Value

Type	Description
string	The OCID of the compartment containing the SQL collection.

Remarks

Required

DbUserName

Declaration

[Required(ErrorMessage = "DbUserName is required.")]
[JsonProperty(PropertyName = "dbUserName")]
public string DbUserName { get; set; }

Property Value

Type	Description
string	The database user name.

Remarks

Required

DefinedTags

Declaration

[JsonProperty(PropertyName = "definedTags")]
public Dictionary<string, Dictionary<string, object>> DefinedTags { get; set; }

Property Value

Type	Description
Dictionary<string, Dictionary<string, object>>	Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations": {"CostCenter": "42"}}

Description

Declaration

[JsonProperty(PropertyName = "description")]
public string Description { get; set; }

Property Value

Type	Description
string	The description of the SQL collection.

DisplayName

Declaration

[Required(ErrorMessage = "DisplayName is required.")]
[JsonProperty(PropertyName = "displayName")]
public string DisplayName { get; set; }

Property Value

Type	Description
string	The display name of the SQL collection.

Remarks

Required

FreeformTags

Declaration

[JsonProperty(PropertyName = "freeformTags")]
public Dictionary<string, string> FreeformTags { get; set; }

Property Value

Type	Description
Dictionary<string, string>	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"}

Id

Declaration

[Required(ErrorMessage = "Id is required.")]
[JsonProperty(PropertyName = "id")]
public string Id { get; set; }

Property Value

Type	Description
string	The OCID of the SQL collection.

Remarks

Required

LifecycleDetails

Declaration

[JsonProperty(PropertyName = "lifecycleDetails")]
public string LifecycleDetails { get; set; }

Property Value

Type	Description
string	Details about the current state of the SQL collection in Data Safe.

LifecycleState

Declaration

[Required(ErrorMessage = "LifecycleState is required.")]
[JsonProperty(PropertyName = "lifecycleState")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlCollectionLifecycleState? LifecycleState { get; set; }

Property Value

Type	Description
SqlCollectionLifecycleState?	The current state of the SQL collection.

Remarks

Required

SqlLevel

Declaration

[JsonProperty(PropertyName = "sqlLevel")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlCollection.SqlLevelEnum? SqlLevel { get; set; }

Property Value

Type	Description
SqlCollection.SqlLevelEnum?	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.

Status

Declaration

[Required(ErrorMessage = "Status is required.")]
[JsonProperty(PropertyName = "status")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlCollection.StatusEnum? Status { get; set; }

Property Value

Type	Description
SqlCollection.StatusEnum?	Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.

Remarks

Required

SystemTags

Declaration

[JsonProperty(PropertyName = "systemTags")]
public Dictionary<string, Dictionary<string, object>> SystemTags { get; set; }

Property Value

Type	Description
Dictionary<string, Dictionary<string, object>>	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"}}

TargetId

Declaration

[Required(ErrorMessage = "TargetId is required.")]
[JsonProperty(PropertyName = "targetId")]
public string TargetId { get; set; }

Property Value

Type	Description
string	The OCID of the target corresponding to the security policy deployment.

Remarks

Required

TimeCreated

Declaration

[Required(ErrorMessage = "TimeCreated is required.")]
[JsonProperty(PropertyName = "timeCreated")]
public DateTime? TimeCreated { get; set; }

Property Value

Type	Description
DateTime?	The time that the SQL collection was created, in the format defined by RFC3339.

Remarks

Required

TimeLastStarted

Declaration

[JsonProperty(PropertyName = "timeLastStarted")]
public DateTime? TimeLastStarted { get; set; }

Property Value

Type	Description
DateTime?	The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.

TimeLastStopped

Declaration

[JsonProperty(PropertyName = "timeLastStopped")]
public DateTime? TimeLastStopped { get; set; }

Property Value

Type	Description
DateTime?	The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.

TimeUpdated

Declaration

[JsonProperty(PropertyName = "timeUpdated")]
public DateTime? TimeUpdated { get; set; }

Property Value

Type	Description
DateTime?	The last date and time the SQL collection was updated, in the format defined by RFC3339.