你当前正在访问 Microsoft Azure Global Edition 技术文档网站。如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

DatabaseBlobAuditingPolicy 构造函数

参考

定义

命名空间:: Microsoft.Azure.Management.Sql.Models

程序集:: Microsoft.Azure.Management.Sql.dll

包:: Microsoft.Azure.Management.Sql v3.1.0-preview

重要

一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。

重载

DatabaseBlobAuditingPolicy()	初始化 DatabaseBlobAuditingPolicy 类的新实例。
DatabaseBlobAuditingPolicy(BlobAuditingPolicyState, String, String, String, String, Nullable<Int32>, IList<String>, Nullable<Boolean>, Nullable<Boolean>, Nullable<Int32>, Nullable<Boolean>, String, String, Nullable<Guid>)	初始化 DatabaseBlobAuditingPolicy 类的新实例。

DatabaseBlobAuditingPolicy()

初始化 DatabaseBlobAuditingPolicy 类的新实例。

public DatabaseBlobAuditingPolicy ();

Public Sub New ()

适用于

DatabaseBlobAuditingPolicy(BlobAuditingPolicyState, String, String, String, String, Nullable<Int32>, IList<String>, Nullable<Boolean>, Nullable<Boolean>, Nullable<Int32>, Nullable<Boolean>, String, String, Nullable<Guid>)

初始化 DatabaseBlobAuditingPolicy 类的新实例。

public DatabaseBlobAuditingPolicy (Microsoft.Azure.Management.Sql.Models.BlobAuditingPolicyState state, string id = default, string name = default, string type = default, string kind = default, int? retentionDays = default, System.Collections.Generic.IList<string> auditActionsAndGroups = default, bool? isStorageSecondaryKeyInUse = default, bool? isAzureMonitorTargetEnabled = default, int? queueDelayMs = default, bool? isManagedIdentityInUse = default, string storageEndpoint = default, string storageAccountAccessKey = default, Guid? storageAccountSubscriptionId = default);

new Microsoft.Azure.Management.Sql.Models.DatabaseBlobAuditingPolicy : Microsoft.Azure.Management.Sql.Models.BlobAuditingPolicyState * string * string * string * string * Nullable<int> * System.Collections.Generic.IList<string> * Nullable<bool> * Nullable<bool> * Nullable<int> * Nullable<bool> * string * string * Nullable<Guid> -> Microsoft.Azure.Management.Sql.Models.DatabaseBlobAuditingPolicy

Public Sub New (state As BlobAuditingPolicyState, Optional id As String = Nothing, Optional name As String = Nothing, Optional type As String = Nothing, Optional kind As String = Nothing, Optional retentionDays As Nullable(Of Integer) = Nothing, Optional auditActionsAndGroups As IList(Of String) = Nothing, Optional isStorageSecondaryKeyInUse As Nullable(Of Boolean) = Nothing, Optional isAzureMonitorTargetEnabled As Nullable(Of Boolean) = Nothing, Optional queueDelayMs As Nullable(Of Integer) = Nothing, Optional isManagedIdentityInUse As Nullable(Of Boolean) = Nothing, Optional storageEndpoint As String = Nothing, Optional storageAccountAccessKey As String = Nothing, Optional storageAccountSubscriptionId As Nullable(Of Guid) = Nothing)

参数

state: BlobAuditingPolicyState

指定审核的状态。如果状态为“已启用”，则需要 storageEndpoint 或 isAzureMonitorTargetEnabled。可能的值包括：“Enabled”、“Disabled”

id: String

资源 ID。

name: String

资源名称。

type: String

资源类型。

kind: String

资源类型。

retentionDays: Nullable<Int32>

指定要在存储帐户的审核日志中保留的天数。

auditActionsAndGroups: IList<String>

指定要审核的Actions-Groups和操作。

         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
         DBCC_GROUP
         DATABASE_OWNERSHIP_CHANGE_GROUP
         DATABASE_CHANGE_GROUP
         LEDGER_OPERATION_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](https://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 &lt;object&gt; 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](https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-action-groups-and-actions#database-level-audit-actions)

isStorageSecondaryKeyInUse: Nullable<Boolean>

指定 storageAccountAccessKey 值是否为存储的辅助密钥。

isAzureMonitorTargetEnabled: Nullable<Boolean>

指定是否将审核事件发送到 Azure Monitor。若要将事件发送到 Azure Monitor，请将“State”指定为“Enabled”，将“IsAzureMonitorTargetEnabled”指定为 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
         https://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](https://go.microsoft.com/fwlink/?linkid=2033207)
         or [Diagnostic Settings
         PowerShell](https://go.microsoft.com/fwlink/?linkid=2033043)

queueDelayMs: Nullable<Int32>

指定在强制处理审核操作之前可以等待的时间（毫秒）。默认的最小值为 1000（1 秒）。最大值为 2，147，483，647。

isManagedIdentityInUse: Nullable<Boolean>

指定是否使用托管标识访问 Blob 存储

storageEndpoint: String

指定 blob 存储终结点 (例如 https://MyAccount.blob.core.windows.net) 。如果状态为 Enabled，则需要 storageEndpoint 或 isAzureMonitorTargetEnabled。

storageAccountAccessKey: String

指定审核存储帐户的标识符密钥。如果状态为“已启用”并指定 storageEndpoint，则不指定 storageAccountAccessKey 将使用 SQL Server 系统分配的托管标识来访问存储。使用托管标识身份验证的先决条件：1. 在 Azure Active Directory (AAD) 中分配SQL Server系统分配的托管标识。 2. 通过向服务器标识添加“存储 Blob 数据参与者”RBAC 角色，向SQL Server标识授予对存储帐户的访问权限。有关详细信息，请参阅使用托管标识身份验证审核存储

storageAccountSubscriptionId: Nullable<Guid>

指定 Blob 存储订阅 ID。

适用于

通过

DatabaseBlobAuditingPolicy 构造函数

定义

重载

DatabaseBlobAuditingPolicy()

适用于

DatabaseBlobAuditingPolicy(BlobAuditingPolicyState, String, String, String, String, Nullable<Int32>, IList<String>, Nullable<Boolean>, Nullable<Boolean>, Nullable<Int32>, Nullable<Boolean>, String, String, Nullable<Guid>)

参数

适用于

反馈

其他资源