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.

No comments posted yet

Your Answer:

Login to answer
162 Like 43 Dislike
Previous forums Next forums
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

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash