
Security
|
113
NOAUDIT
NOAUDIT sql_statement_clause | schema_object_clause
[BY SESSION | ACCESS]
Turns off any previously started audits. The keywords and clauses
for NOAUDIT have the same meaning as for the AUDIT
statement.
Other Security Features
The security features described in the following sections are
most relevant to Oracle system administrators or security
administrators. We provide only a brief overview of these
features; see the Oracle documentation for complete details.
Views
In addition to the security features described in previous sec-
tions, views are commonly used to limit access to data. With
a view, you define a subset of data in a table based on the
data values and then grant the user access to that view. You
can achieve the same “security by selection” with the use of
fine-grained access control (see “Fine-grained access control
and security policy”).
Stored procedures
You can impose a similar limitation by granting users access
to a table only through a stored procedure or package. In
addition, the stored procedure can have its own validation
rules within its code.
Fine-grained access control and security policy
Fine-grained access control (FGAC) provides the type of
context-sensitive security that used to be implemented in
application code or views. But because FGAC is enforced by
the database, it is consistently applied across all applications.