Please refer to Table 13-3 for a list of these options.ĪLL Specify ALL as a shortcut equivalent to specifying all object options applicable for the type of object.Īuditing_on_clause The auditing_on_clause lets you specify the particular schema object for which auditing is to be stopped.įor object, specify the object name of a table, view, sequence, stored procedure, function, or package, materialized view, or library. Object_optionFor object_option, specify the type of operation for which auditing is to be stopped on the object specified in the ON clause. Use the schema_object_clause to stop auditing of a particular database object. Specify BY proxy to stop auditing only for the SQL statements issued by the specified proxy, on behalf of a specific user or any user.
If you omit this clause, then Oracle Database stops auditing for all users' statements, except for the situation described for WHENEVER SUCCESSFUL. Specify BY user to stop auditing only for SQL statements issued by the specified users in their subsequent sessions. If you omit this clause, then Oracle Database stops auditing all users' statements. Please refer to Table 18-1 for a list of the system privileges and the statements they authorize.ĪLL PRIVILEGES Specify ALL PRIVILEGES to stop auditing of all system privileges currently being audited.Īuditing_by_clauseUse the auditing_by_clause to stop auditing only those SQL statements issued by particular users. System_privilegeFor system_privilege, specify the system privilege for which auditing is to be stopped. Please refer to Table 13-1 and Table 13-2 for a list of the statement options and the SQL statements they audit.ĪLL Specify ALL to stop auditing of all statement options currently being audited. Statement_optionFor statement_option, specify the statement option for which auditing is to be stopped. Use the sql_statement_clause to stop auditing of a particular SQL statement. ( sql_statement_clause ::=, schema_object_clause ::=)ĭescription of the illustration sql_statement_clause.gifĭescription of the illustration auditing_by_clause.gifĭescription of the illustration schema_object_clause.gifĭescription of the illustration auditing_on_clause.gif In addition, if the object you chose for auditing is a directory, then even if you created it, you must have the AUDIT ANY system privilege.ĭescription of the illustration noaudit.gif To stop auditing of schema objects, you must be the owner of the object on which you stop auditing or you must have the AUDIT ANY system privilege. To stop auditing of SQL statements, you must have the AUDIT SYSTEM system privilege. See Also: AUDIT for more information on auditing
0 kommentar(er)
