Oracle:

NOAUDIT

NOAUDIT
{ audit_operation_clause [ auditing_by_clause ]
| audit_schema_object_clause
| NETWORK
}
[ WHENEVER [ NOT ] SUCCESSFUL ] ;

audit_operation_clause ::=
{ { sql_statement_shortcut
| ALL
| ALL STATEMENTS
} [, { sql_statement_shortcut
| ALL
}
]
| { system_privilege
| ALL PRIVILEGES
} [, { system_privilege
| ALL PRIVILEGES
}
]
}
auditing_by_clause::=
BY user [, user ]...
audit_schema_object_clause ::=
{ sql_operation [, object_option]
| ALL
} auditing_on_clause
auditing_on_clause ::=
ON { [ schema. ] object
| DIRECTORY directory_name
| MINING MODEL [ schema. ] model
| DEFAULT
}

example

NOAUDIT ROLE;

NOAUDIT SELECT TABLE BY hr;

NOAUDIT DELETE ANY TABLE;

NOAUDIT SELECT
ON hr.employees;

NOAUDIT SELECT
ON hr.employees
WHENEVER SUCCESSFUL;