|
-
 Originally Posted by Thobela
I solved this by using a VPD policy to generate the predicate on the fly. so I am using an OLS policy together with a VPD policy on the same table.
what I had hoped for was using just an OLS policy and provide a SQL function for the predicate option/argument when applying the OLS policy to a table such that this function is called when the OLS policy is being enforced (meaning that the predicate would be generated on the fly based on user session).
Pablo, thanks for you replies.
Nicely done, congrats!
Glad to help.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote