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...

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.

Your Answer:

Login to answer

Other forums

Strange cookie problem. setcookie dependant on where user was directed from?
Hello,

I have a website that sets a cookie when a user visits the website. The cookie holds a

PHP Script runs on CLI but not through web browser
I am running into an issue that I just can't seem to find the answer to. I have a Windows Server 200

Help: calling function
Hi,
Is it possible to call a php function on page close?
If yes, could you explain how and whe

Help with email validation please...
Hi,
Please could you help.
I have a register.php login page where users register, the detail

void* and sizeof()
Hi,

Using void* and sizeof is it possible to get the value of the object ?

I understan

Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Is this Safe or Unsafe?
Hi i made a few pages with lots of peoples help now i just want to know if they are safe or not can

Please help with code for SMTP authenticated PHP email form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authenticat

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

Loop column after 2 results
Hello All.

Here is what I have:

Client ID Company name Clien