Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace SqlFirewallAllowedSqlSummary

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

Properties

compartmentId

compartmentId: string

The OCID of the compartment containing the SQL Firewall allowed SQL.

Optional currentUser

currentUser: undefined | string

The name of the user that SQL was executed as.

dbUserName

dbUserName: string

The database user name.

Optional definedTags

definedTags: undefined | object

Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags

Example: {@code {\"Operations\": {\"CostCenter\": \"42\"}}}

Optional description

description: undefined | string

The description of the SQL Firewall allowed SQL.

displayName

displayName: string

The display name of the SQL Firewall allowed SQL.

Optional freeformTags

freeformTags: undefined | object

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: {@code {\"Department\": \"Finance\"}}

id

id: string

The OCID of the SQL Firewall allowed SQL.

lifecycleState

The current state of the SQL Firewall allowed SQL.

Optional sqlAccessedObjects

sqlAccessedObjects: Array<string>

The objects accessed by the SQL.

sqlFirewallPolicyId

sqlFirewallPolicyId: string

The OCID of the SQL Firewall policy corresponding to the SQL Firewall allowed SQL.

sqlLevel

sqlLevel: SqlLevel

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.

sqlText

sqlText: string

The SQL text of the SQL Firewall allowed SQL.

Optional systemTags

systemTags: undefined | object

System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {@code {"orcl-cloud": {"free-tier-retained": "true"}}}

timeCollected

timeCollected: Date

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

Optional timeUpdated

timeUpdated: Date

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

version

version: number

Version of the associated SQL Firewall policy. This identifies whether the allowed SQLs were added in the same batch or not. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Functions

getDeserializedJsonObj

getJsonObj