Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures

 

sa_disable_auditing_type system procedure

Disables auditing of specific events.

Syntax
sa_disable_auditing_type(' types ')
Arguments
  • types   Use this VARCHAR(128) parameter to specify a comma-delimited string containing one or more of the following values:

    • all   disables all types of auditing.

    • connect   disables auditing of both successful and failed connection attempts.

    • connectFailed   disables auditing of failed connection attempts.

    • DDL   disables auditing of DDL statements.

    • options   disables auditing of public options.

    • permission   disables auditing of permission checks, user checks, and SETUSER statements.

    • permissionDenied   disables auditing of failed permission and user checks.

    • triggers   disables auditing in response to trigger events.

Remarks

You can use the sa_disable_auditing_type system procedure to disable auditing of one or more categories of information.

Setting this option to all disables all auditing. You can also disable auditing by setting the PUBLIC.auditing option to Off.

Permissions

DBA authority required

Side effects

None

See also
Example

To disable all auditing:

CALL sa_disable_auditing_type( 'all' );