Show / Hide Table of Contents

Class SqlFirewallPolicySummary

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

Inheritance
object
SqlFirewallPolicySummary
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 SqlFirewallPolicySummary

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 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 SqlFirewallPolicySummary.EnforcementScopeEnum? EnforcementScope { get; set; }
Property Value
Type Description
SqlFirewallPolicySummary.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 SqlFirewallPolicySummary.SqlLevelEnum? SqlLevel { get; set; }
Property Value
Type Description
SqlFirewallPolicySummary.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 SqlFirewallPolicySummary.StatusEnum? Status { get; set; }
Property Value
Type Description
SqlFirewallPolicySummary.StatusEnum?

Specifies whether the SQL Firewall policy is enabled or disabled.

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 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 SqlFirewallPolicySummary.ViolationActionEnum? ViolationAction { get; set; }
Property Value
Type Description
SqlFirewallPolicySummary.ViolationActionEnum?

Specifies the SQL Firewall action based on detection of SQL Firewall violations.

ViolationAudit

Declaration
[JsonProperty(PropertyName = "violationAudit")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlFirewallPolicySummary.ViolationAuditEnum? ViolationAudit { get; set; }
Property Value
Type Description
SqlFirewallPolicySummary.ViolationAuditEnum?

Specifies whether a unified audit policy should be enabled for auditing the SQL Firewall policy violations.

In this article
Back to top