Class SqlFirewallViolationSummary
The resource represents the SQL violations collected from the target database by Oracle Data Safe.
Inherited Members
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. |