Class SqlFirewallPolicy

The SQL Firewall policy resource contains the firewall policy metadata for a single user.

Inheritance

object

SqlFirewallPolicy

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 SqlFirewallPolicy

Properties

AllowedClientIps

Declaration

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

Property Value

Type	Description
List<string>	The list of allowed ip addresses for the SQL Firewall policy.

AllowedClientOsUsernames

Declaration

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

Property Value

Type	Description
List<string>	The list of allowed operating system user names for the SQL Firewall policy.

AllowedClientPrograms

Declaration

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

Property Value

Type	Description
List<string>	The list of allowed client programs for the SQL Firewall policy.

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 policy.

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 Firewall policy.

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 policy.

Remarks

Required

EnforcementScope

Declaration

[JsonProperty(PropertyName = "enforcementScope")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlFirewallPolicy.EnforcementScopeEnum? EnforcementScope { get; set; }

Property Value

Type	Description
SqlFirewallPolicy.EnforcementScopeEnum?	Specifies the SQL Firewall policy enforcement option.

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 policy.

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 Firewall policy in Data Safe.

LifecycleState

Declaration

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

Property Value

Type	Description
SqlFirewallPolicyLifecycleState?	The current state of the SQL Firewall policy.

Remarks

Required

SecurityPolicyId

Declaration

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

Property Value

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

Remarks

Required

SqlLevel

Declaration

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

Property Value

Type	Description
SqlFirewallPolicy.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.

Status

Declaration

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

Property Value

Type	Description
SqlFirewallPolicy.StatusEnum?	Specifies whether the SQL Firewall policy is enabled or disabled.

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

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 Firewall policy was created, in the format defined by RFC3339.

Remarks

Required

TimeUpdated

Declaration

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

Property Value

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

ViolationAction

Declaration

[JsonProperty(PropertyName = "violationAction")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlFirewallPolicy.ViolationActionEnum? ViolationAction { get; set; }

Property Value

Type	Description
SqlFirewallPolicy.ViolationActionEnum?	Specifies the mode in which the SQL Firewall policy is enabled.

ViolationAudit

Declaration

[JsonProperty(PropertyName = "violationAudit")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlFirewallPolicy.ViolationAuditEnum? ViolationAudit { get; set; }

Property Value

Type	Description
SqlFirewallPolicy.ViolationAuditEnum?	Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.