Re: Row level security
> You create VIEW for each user and give him access to this VIEW only and not to the base table.
> CREATE VIEW v_user123 AS (SELECT * FROM tbl WHERE userid=123);
I don't have strong confidence, but I think you need not only views but also triggers and stored procuedures.
Subject
Views
Written By
Posted
15483
December 01, 2005 08:27AM
6700
December 07, 2005 12:19AM
Re: Row level security
6355
March 25, 2006 11:43PM
5488
March 15, 2006 06:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.