CREATE SERVER AUDIT |
Crée un audit de serveur |
|---|---|
| Microsoft SQL Server |
Syntaxe
|
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_options::= { FILEPATH = 'os_file_path' [ , MAXSIZE = { max_size { MB | GB | TB } | UNLIMITED } ] [ , { MAX_ROLLOVER_FILES = { integer | UNLIMITED } } | { MAX_FILES = integer } ] [ , RESERVE_DISK_SPACE = { ON | OFF } ] } audit_options::= { [ QUEUE_DELAY = integer ] [ , ON_FAILURE = { CONTINUE | SHUTDOWN | FAIL_OPERATION } ] [ , AUDIT_GUID = uniqueidentifier ] } predicate_expression::= { [NOT ] predicate_factor [ { AND | OR } [NOT ] { predicate_factor } ] [,...n ] } predicate_factor::= event_field_name { = | < > | ! = | > | > = | < | < = | LIKE } { number | ' string ' } |
Description
Cette instruction permet de créer un objet de journal de bord serveur utilisé par le SQL Server Audit.
Dernière mise à jour : Vendredi, le 19 Juin 2020