Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
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.
114
|
Oracle DBA Pocket Guide
FGAC is implemented ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843