retrieving policy name inside the function called by this particular policy
Posted on
16th Feb 2014 07:03 pm by
admin
Hi there,
I've playing around with dbms_rls package, trying to set up some security repository, linking users to what
columns and row values they are allowed to see etc...
Did you know?Explore Trending and Topic pages for more stories like this.
A policy, applied on a table, causes a custom made function to be executed and returns the where clause that
should be added to a select on that table. So far, so good.
Now, is it possible to trap, inside this trigger, the name of the policy that caused this trigger to fire ... ?
If I could have this, it would be possible to make up one single function, used by each policy, that would,
based on some repository table containing the os_user, table, columns, operator strings, values to which the
operator is applied, and of course the policy name, return the exact where clause, by combining the information
in the repository table.
No comments posted yet
Your Answer:
Login to answer
162 
43 
Other forums
Problems with strings containing
Hey all,
I have encountered something strange in a script. I am trying to write an XML heade
phpMailer will not connect using SMTP
I am trying to use phpMailer with smtp:
Code: [Select]$mailer = new PHPMailer();
$mailer-&
Undefined variable: adHTML
Hello:
While checking my site error logs, I've noticed one repetitive error that fills the lo
Impact of movement type 412 E on MAP
Hi
Usage of movement type 412 E is causing huge change in MAP .
Is there any r
2 decima places & How to reload my page
Hello There,
How do i put full-stop (.) after second figure from behind? ie if i have 123456
PHP header help!
Hi all I am trying to get this php page to refresh every 5 seconds on my phone which is an aastra 48
Need help in Generating Combinations
Need help generating all possible combination of names in an array
Lets say i have the follow
TimeStamp Column Problem...
I'm mad at my self and thinking I'm a little retarded. It just be some one mistake I'm missing here.
ALV grid with 2 headers
Hi Gurus,
I need to display ALV GRID as below.
Header1
A problem with my GD class
Hello,
I created a nice (and simple for now) GD class.
The problem is , it works great on
