Class SqlFirewallAllowedSql

The resource represents a SQL Firewall allowed SQL in Data Safe.

Inheritance

object

SqlFirewallAllowedSql

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 SqlFirewallAllowedSql

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 Firewall allowed SQL.

Remarks

Required

CurrentUser

Declaration

[JsonProperty(PropertyName = "currentUser")]
public string CurrentUser { get; set; }

Property Value

Type	Description
string	The name of the user that SQL was executed as.

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 Firewall allowed SQL.

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 Firewall allowed SQL.

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 Firewall allowed SQL.

Remarks

Required

LifecycleState

Declaration

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

Property Value

Type	Description
SqlFirewallAllowedSqlLifecycleState?	The current state of the SQL Firewall allowed SQL.

Remarks

Required

SqlAccessedObjects

Declaration

[JsonProperty(PropertyName = "sqlAccessedObjects")]
public List<string> SqlAccessedObjects { get; set; }

Property Value

Type	Description
List<string>	The objects accessed by the SQL.

SqlFirewallPolicyId

Declaration

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

Property Value

Type	Description
string	The OCID of the SQL Firewall policy corresponding to the SQL Firewall allowed SQL.

Remarks

Required

SqlLevel

Declaration

[Required(ErrorMessage = "SqlLevel is required.")]
[JsonProperty(PropertyName = "sqlLevel")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlFirewallAllowedSql.SqlLevelEnum? SqlLevel { get; set; }

Property Value

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

Remarks

Required

SqlText

Declaration

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

Property Value

Type	Description
string	The SQL text of the SQL Firewall allowed SQL.

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"}}

TimeCollected

Declaration

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

Property Value

Type	Description
DateTime?	The time the the SQL Firewall allowed SQL was collected from the target database, in the format defined by RFC3339.

Remarks

Required

TimeUpdated

Declaration

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

Property Value

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

Version

Declaration

[Required(ErrorMessage = "Version is required.")]
[JsonProperty(PropertyName = "version")]
public float? Version { get; set; }

Property Value

Type	Description
float?	Version of the associated SQL Firewall policy. This identifies whether the allowed SQLs were added in the same batch or not.

Remarks

Required