Class SqlFirewallViolationSummary

The resource represents the SQL violations collected from the target database by Oracle Data Safe.

Inheritance

object

SqlFirewallViolationSummary

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 SqlFirewallViolationSummary

Properties

ClientIp

Declaration

[JsonProperty(PropertyName = "clientIp")]
public string ClientIp { get; set; }

Property Value

Type	Description
string	The IP address of the host machine from which the session was generated.

ClientOsUserName

Declaration

[JsonProperty(PropertyName = "clientOsUserName")]
public string ClientOsUserName { get; set; }

Property Value

Type	Description
string	The name of the operating system user for the database session.

ClientProgram

Declaration

[JsonProperty(PropertyName = "clientProgram")]
public string ClientProgram { get; set; }

Property Value

Type	Description
string	The application from which the SQL violation was generated. Examples include SQL Plus or SQL Developer.

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

Remarks

Required

CurrentDbUserName

Declaration

[JsonProperty(PropertyName = "currentDbUserName")]
public string CurrentDbUserName { get; set; }

Property Value

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

DbUserName

Declaration

[JsonProperty(PropertyName = "dbUserName")]
public string DbUserName { get; set; }

Property Value

Type	Description
string	The name of the database user.

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

Remarks

Required

Operation

Declaration

[JsonProperty(PropertyName = "operation")]
public string Operation { get; set; }

Property Value

Type	Description
string	The name of the action executed by the user on the target database. For example, ALTER, CREATE, DROP.

OperationTime

Declaration

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

Property Value

Type	Description
DateTime?	The time of the SQL violation occurrence in the target database.

Remarks

Required

SqlAccessedObjects

Declaration

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

Property Value

Type	Description
string	The objects accessed by the SQL.

SqlLevel

Declaration

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

Property Value

Type	Description
SqlFirewallViolationSummary.SqlLevelEnum?	Specifies the level of SQL for this violation. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.

SqlText

Declaration

[JsonProperty(PropertyName = "sqlText")]
public string SqlText { get; set; }

Property Value

Type	Description
string	The SQL text caught by the firewall.

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

Remarks

Required

TargetName

Declaration

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

Property Value

Type	Description
string	The name of the target database.

Remarks

Required

TimeCollected

Declaration

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

Property Value

Type	Description
DateTime?	The timestamp when this SQL violation was collected from the target database by Data Safe.

Remarks

Required

ViolationAction

Declaration

[Required(ErrorMessage = "ViolationAction is required.")]
[JsonProperty(PropertyName = "violationAction")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlFirewallViolationSummary.ViolationActionEnum? ViolationAction { get; set; }

Property Value

Type	Description
SqlFirewallViolationSummary.ViolationActionEnum?	The action taken for this SQL violation.

Remarks

Required

ViolationCause

Declaration

[JsonProperty(PropertyName = "violationCause")]
public string ViolationCause { get; set; }

Property Value

Type	Description
string	Indicates whether SQL or context violation.