Transact-SQL 语法约定 语法 syntaxsql 复制 CREATE SERVER AUDIT audit_name { TO { [ FILE (<file_options> [ , ...n ] ) ] | APPLICATION_LOG | SECURITY_LOG | URL | EXTERNAL_MONITOR } [ WITH ( <audit_options> [ , ...n ]
Transact-SQL 语法约定 语法 syntaxsql 复制 CREATE SERVER AUDIT audit_name { TO { [ FILE (<file_options> [ , ...n ] ) ] | APPLICATION_LOG | SECURITY_LOG | URL | EXTERNAL_MONITOR } [ WITH ( <audit_options> [ , ...n ] ) ] [ WHERE <predicate_expression> ] } [ ; ] <file...
具有ALTER ANY SERVER AUDIT 权限的用户可以创建服务器审核规范并将其绑定到任何审核。 创建服务器审核规范后,具有 CONTROL SERVER 权限的用户、sysadmin 帐户或具有对审核的明确访问权的主体即可查看该规范。 示例 下面的示例针对被称为HIPAA_Audit的 SQL Server 审核创建名为HIPAA_Audit_Specification的服务器审核规范,...
本文中的 Transact-SQL 代码示例使用AdventureWorks2022或AdventureWorksDW2022示例数据库,可从Microsoft SQL Server 示例和社区项目主页下载它。 A. 审核任何数据库主体的表上的 SELECT 和 INSERT 以下示例为表创建一个调用Payroll_Security_Audit的服务器审核,然后创建一个数据库审核规范,HumanResources.EmployeePayHistory该...
The audit is at the SQL Server instance level. You can have multiple audits per SQL Server instance. The Server Audit Specification object belongs to an audit. You can create one server audit specification per audit, because both are created at the SQL Server instance scope. For more ...
SERVER AUDIT SERVER AUDIT SPECIFICATION SERVER ROLE SERVICE SPATIAL INDEX STATISTICS SYMMETRIC KEY SYNONYM TABLE TABLE (SQL Graph) TABLE IDENTITY (Propriedade) TRIGGER TYPE USER VIEW WORKLOAD GROUP XML INDEX XML INDEX (Índices XML seletivos) XML SCHEMA COLLECTION Ordenações DROP Permissões Age...
IServerAuditFacet IServerConfigurationFacet IServerInformation IServerPerformanceFacet IServerSecurityFacet IServerSelectionFacet IServerSettings IServerSetupFacet ISmartAdminState ISmoApplicationEvents ISmoDependencyDiscoverer ISmoScriptWriter ISurfaceAreaFacet ITableOptions ITextObject IUserOptions IViewOpt...
-- Create the server audit CREATESERVER AUDIT test_audit TOFILE ( FILEPATH = 'C:\cases\Cluster\116020613677365- SQL server not starting up in cluster'); GO -- Enable the server audit ALTERSERVER AUDIT test_audit WITH(STATE =ON) ;
程序集: Microsoft.SqlServer.TransactSql.ScriptDom(在 Microsoft.SqlServer.TransactSql.ScriptDom.dll 中) 语法 C# 复制 [SerializableAttribute] public class CreateDatabaseAuditSpecificationStatement : AuditSpecificationStatement CreateDatabaseAuditSpecificationStatement 类型公开以下成员。 构造函数 展开表 名称说明...
Assume that you enable bothRow-Level SecurityandSQL Server auditon a table in SQL Server 2016. When you execute a CREATE SECURITY POLICY statement, anaudit recordis created, however, the audit record doesn't have the correct schema_name and class_type values. ...