Class: Azure::SQL::Mgmt::V2017_03_01_preview::Models::ExtendedServerBlobAuditingPolicy

Inherits:
ProxyResource
  • Object
show all
Includes:
MsRestAzure
Defined in:
lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb

Overview

An extended server blob auditing policy.

Instance Attribute Summary collapse

Attributes inherited from Resource

#id, #name, #type

Class Method Summary collapse

Methods inherited from Resource

#resource_group

Instance Attribute Details

#audit_actions_and_groups ⇒ Array<String>

audit.

The recommended set of action groups to use is the following combination - this will audit all the queries and stored procedures executed against the database, as well as successful and failed logins:

BATCH_COMPLETED_GROUP, SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP, FAILED_DATABASE_AUTHENTICATION_GROUP.

This above combination is also the set that is configured by default when enabling auditing from the Azure portal.

The supported action groups to audit are (note: choose only specific groups that cover your auditing needs. Using unnecessary groups could lead to very large quantities of audit records):

APPLICATION_ROLE_CHANGE_PASSWORD_GROUP BACKUP_RESTORE_GROUP DATABASE_LOGOUT_GROUP DATABASE_OBJECT_CHANGE_GROUP DATABASE_OBJECT_OWNERSHIP_CHANGE_GROUP DATABASE_OBJECT_PERMISSION_CHANGE_GROUP DATABASE_OPERATION_GROUP DATABASE_PERMISSION_CHANGE_GROUP DATABASE_PRINCIPAL_CHANGE_GROUP DATABASE_PRINCIPAL_IMPERSONATION_GROUP DATABASE_ROLE_MEMBER_CHANGE_GROUP FAILED_DATABASE_AUTHENTICATION_GROUP SCHEMA_OBJECT_ACCESS_GROUP SCHEMA_OBJECT_CHANGE_GROUP SCHEMA_OBJECT_OWNERSHIP_CHANGE_GROUP SCHEMA_OBJECT_PERMISSION_CHANGE_GROUP SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP USER_CHANGE_PASSWORD_GROUP BATCH_STARTED_GROUP BATCH_COMPLETED_GROUP

These are groups that cover all sql statements and stored procedures executed against the database, and should not be used in combination with other groups as this will result in duplicate audit logs.

For more information, see [Database-Level Audit Action Groups](docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-action-groups-and-actions#database-level-audit-action-groups).

For Database auditing policy, specific Actions can also be specified (note that Actions cannot be specified for Server auditing policy). The supported actions to audit are: SELECT UPDATE INSERT DELETE EXECUTE RECEIVE REFERENCES

The general form for defining an action to be audited is: action ON object BY principal

Note that <object> in the above format can refer to an object like a table, view, or stored procedure, or an entire database or schema. For the latter cases, the forms DATABASE::db_name and SCHEMA::schema_name are used, respectively.

For example: SELECT on dbo.myTable by public SELECT on DATABASE::myDatabase by public SELECT on SCHEMA::mySchema by public

For more information, see [Database-Level Audit Actions](docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-action-groups-and-actions#database-level-audit-actions)

Returns:

  • (Array<String>) —

    Specifies the Actions-Groups and Actions to



110
111
112
 
# File 'lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb', line 110

def audit_actions_and_groups
  @audit_actions_and_groups
end

#is_azure_monitor_target_enabled ⇒ Boolean

Monitor. In order to send the events to Azure Monitor, specify ‘state’ as ‘Enabled’ and ‘isAzureMonitorTargetEnabled’ as true.

When using REST API to configure auditing, Diagnostic Settings with ‘SQLSecurityAuditEvents’ diagnostic logs category on the database should be also created. Note that for server level audit you should use the ‘master’ database as databaseName.

Diagnostic Settings URI format: PUT management.azure.com/subscriptions/subscriptionId/resourceGroups/resourceGroup/providers/Microsoft.Sql/servers/serverName/databases/databaseName/providers/microsoft.insights/diagnosticSettings/settingsName?api-version=2017-05-01-preview

For more information, see [Diagnostic Settings REST API](go.microsoft.com/fwlink/?linkid=2033207) or [Diagnostic Settings PowerShell](go.microsoft.com/fwlink/?linkid=2033043)

Returns:

  • (Boolean) —

    Specifies whether audit events are sent to Azure



139
140
141
 
# File 'lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb', line 139

def is_azure_monitor_target_enabled
  @is_azure_monitor_target_enabled
end

#is_storage_secondary_key_in_use ⇒ Boolean

the storage’s secondary key.

Returns:

  • (Boolean) —

    Specifies whether storageAccountAccessKey value is



117
118
119
 
# File 'lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb', line 117

def is_storage_secondary_key_in_use
  @is_storage_secondary_key_in_use
end

#predicate_expression ⇒ String

audit.

Returns:

  • (String) —

    Specifies condition of where clause when creating an



17
18
19
 
# File 'lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb', line 17

def predicate_expression
  @predicate_expression
end

#queue_delay_ms ⇒ Integer

elapse before audit actions are forced to be processed. The default minimum value is 1000 (1 second). The maximum is 2,147,483,647.

Returns:

  • (Integer) —

    Specifies the amount of time in milliseconds that can



145
146
147
 
# File 'lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb', line 145

def queue_delay_ms
  @queue_delay_ms
end

#retention_days ⇒ Integer

logs in the storage account.

Returns:

  • (Integer) —

    Specifies the number of days to keep in the audit



36
37
38
 
# File 'lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb', line 36

def retention_days
  @retention_days
end

#state ⇒ BlobAuditingPolicyState

state is Enabled, storageEndpoint or isAzureMonitorTargetEnabled are required. Possible values include: ‘Enabled’, ‘Disabled’

Returns:



22
23
24
 
# File 'lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb', line 22

def state
  @state
end

#storage_account_access_key ⇒ String

account. If state is Enabled and storageEndpoint is specified, storageAccountAccessKey is required.

Returns:

  • (String) —

    Specifies the identifier key of the auditing storage



32
33
34
 
# File 'lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb', line 32

def 
  
end

#storage_account_subscription_id ⇒ Object

Returns Specifies the blob storage subscription Id.

Returns:

  • Specifies the blob storage subscription Id.



113
114
115
 
# File 'lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb', line 113

def 
  
end

#storage_endpoint ⇒ String

MyAccount.blob.core.windows.net). If state is Enabled, storageEndpoint or isAzureMonitorTargetEnabled is required.

Returns:

  • (String) —

    Specifies the blob storage endpoint (e.g.



27
28
29
 
# File 'lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb', line 27

def storage_endpoint
  @storage_endpoint
end

Class Method Details

.mapper ⇒ Object

Mapper for ExtendedServerBlobAuditingPolicy class as Ruby Hash. This will be used for serialization/deserialization.



152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
 
# File 'lib/2017-03-01-preview/generated/azure_mgmt_sql/models/extended_server_blob_auditing_policy.rb', line 152

def self.mapper()
  {
    client_side_validation: true,
    required: false,
    serialized_name: 'ExtendedServerBlobAuditingPolicy',
    type: {
      name: 'Composite',
      class_name: 'ExtendedServerBlobAuditingPolicy',
      model_properties: {
        id: {
          client_side_validation: true,
          required: false,
          read_only: true,
          serialized_name: 'id',
          type: {
            name: 'String'
          }
        },
        name: {
          client_side_validation: true,
          required: false,
          read_only: true,
          serialized_name: 'name',
          type: {
            name: 'String'
          }
        },
        type: {
          client_side_validation: true,
          required: false,
          read_only: true,
          serialized_name: 'type',
          type: {
            name: 'String'
          }
        },
        predicate_expression: {
          client_side_validation: true,
          required: false,
          serialized_name: 'properties.predicateExpression',
          type: {
            name: 'String'
          }
        },
        state: {
          client_side_validation: true,
          required: true,
          serialized_name: 'properties.state',
          type: {
            name: 'Enum',
            module: 'BlobAuditingPolicyState'
          }
        },
        storage_endpoint: {
          client_side_validation: true,
          required: false,
          serialized_name: 'properties.storageEndpoint',
          type: {
            name: 'String'
          }
        },
        storage_account_access_key: {
          client_side_validation: true,
          required: false,
          serialized_name: 'properties.storageAccountAccessKey',
          type: {
            name: 'String'
          }
        },
        retention_days: {
          client_side_validation: true,
          required: false,
          serialized_name: 'properties.retentionDays',
          type: {
            name: 'Number'
          }
        },
        audit_actions_and_groups: {
          client_side_validation: true,
          required: false,
          serialized_name: 'properties.auditActionsAndGroups',
          type: {
            name: 'Sequence',
            element: {
                client_side_validation: true,
                required: false,
                serialized_name: 'StringElementType',
                type: {
                  name: 'String'
                }
            }
          }
        },
        storage_account_subscription_id: {
          client_side_validation: true,
          required: false,
          serialized_name: 'properties.storageAccountSubscriptionId',
          type: {
            name: 'String'
          }
        },
        is_storage_secondary_key_in_use: {
          client_side_validation: true,
          required: false,
          serialized_name: 'properties.isStorageSecondaryKeyInUse',
          type: {
            name: 'Boolean'
          }
        },
        is_azure_monitor_target_enabled: {
          client_side_validation: true,
          required: false,
          serialized_name: 'properties.isAzureMonitorTargetEnabled',
          type: {
            name: 'Boolean'
          }
        },
        queue_delay_ms: {
          client_side_validation: true,
          required: false,
          serialized_name: 'properties.queueDelayMs',
          type: {
            name: 'Number'
          }
        }
      }
    }
  }
end