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

Quick Syntax Question
Hi folks,

I'm getting the following error: "unexpected T_LNUMBER". I'm trying to b

Exporting new records
Trying to figure out the best way to set this up.

People register my site.

Their prof

Xacute search within SQL results
I have a query that is pulling data, and I want to return a specific value from the results of that

puting for loop in 1 value
hi ,

how do i put this code in 1 value:
Code: <?php
for ($i=1; $i<=5; $i

upload form file types....
Hey all, I am learning PHP and I am writing a script from the W3C Schools tutorials for uploading fi

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

Find current logon time
Hi,
in my sql script i want to query and find out the logon time of the current session.
<

Sending CC Info by email
I am a little bit less knowledgable in the security area as most developers and I know I have a lot

Wordpress IE issue
So I am trying to add the background shadow to my wordpress page. It works fine in Firefox but does

Displaying Column Names
I have a question regarding the ability to show the column names from my table/query.
What I'm lo