Re: row-level security model

On Apr 1, 2004, at 10:55 AM, Jim C. Nasby wrote:

> Yes, but Oracle has much more advanced support for row-level security.
> Look for Fine-Grain Access Controll in the docs.

I found this nice article with examples on row level security with
Oracle:

This is the core functionality of the row level security
implementation. This function is what checks the context for the
current user in line with the business rules defined above and
implemented in the functions to set the security context. The function
then, based on the rights of the user executing the select statement or
update, insert or delete returns a predicate. This predicate is a
dynamic piece of SQL that is appended to the where clause of the
executing SQL by the Oracle optimizer at the time the SQL is parsed and
executed.

http://www.securityfocus.com/infocus/1743

John DeSoi, Ph.D.