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

problem in pagination when processing with selectbox form
Hi,

I have a search form, with select boxes, if am selecting the value from the form, it work

Database connection failure
Hello All,

I am trying to create new connection to Oracle DB 10.1,
I could not see a

Hyperlink in PHP to MySQL record
Hello,

I am having trouble as i am new to php. I have connected to the database and I have di

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to

Sequencing or queuing parallel process
Scenario is as follows
There is one parent process say P1 and 4 child processes say A B C D

line breaks in between fetched file names
Hi,

I have this code:
Code: <?php
if($dir = opendir('files')){
while (($f

Function module "DPS_CHECK_TABLE_EXISTS" not found (after OSS 1422843 impl)
Dear All,

I implemented Note OSS 1422843.

When i execute the new report RSPO20

how can i expire the submitted page using session.
hi,
i'm new to php world.
i'm using "post" method.
when i submit it,data goes to

eregi to preg
Im converting my regex for php 5.3 and I am stuck on the following

Code: [Select]if((eregi(&q

Interpret Order
Hello all,

I'm wondering if I have this:

Code: $switch = array(
'one' =>