Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Fine-grained Access Control and Security Policy

Fine-grained access control provides the type of context-sensitive security that used to be implemented in application code or views. But because fine-grained access control is enforced by the database, it is consistently applied across all applications.

Fine-grained access control, introduced in Oracle8i, is implemented by having a security policy associated with a table implement security on that table. The security policy is a program unit that can grant access based on any kind of logical condition. The security policy creates a predicate (a condition added to the WHERE clause to limit data accessed) for any SQL statements issued against the database, which automatically can be used to implement security based on the content of data in the table.

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 Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page