then what actually gets executed is
SELECT * FROM table_x;
For more, see the 2 Day + Data Warehousing Guide
SELECT * FROM table_x WHERE company_id = 123;
user12083970 wrote:Yes, it's been around since Oracle 8.1 (at least).
Hi Brendan, Frank,
Thanks for the comments.
We have done a small POC and understand that the RLS can work inplace of the view solution. However, we are not sure if the RLS is a proven technology?
Does it require additional Oracle license when using Enterprise Edition?As far as I know, it requires Enterprise Edition, but nothing more. As always, check with your Oracle rep to be sure; don't rely on what you hear in a forum like this.
The company_id on every table will determine which company that record belongs to. Hope this is what you were asking.
What is it that determines what 'company' a given record belongs to?
How do you determine what 'company' that one row belongs to? What information in that table/row can be used to determine what company the row belongs to?
SELECT * FROM myTable where rownum = 1;