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.
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
