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

DB2 for z/OS, LUW, iSeries
Hello, In this forum a lot of threads related to other members of the DB2 family than DB2 for z/OS

Material xxx does not exist in plant xxx
Dear All,

I am working for a steel project which is repetitive manufacturing.

my sql select id and then update problem.
I need to select some auto incremented ids out of a database and then use those id in a where statem

BI in Upstream Production operations
Appreciate if you can assist in the following areas:
1) Examples of life before and after BI i

Locking mysql tables with php
Hi

BACKGROUND:
I have multiple instances of the same php script running in a WAMP environ

Saving data from a form into a file
Hey everybody,

Sorry, I am really new to PHP coding and such but a project kind of got thrust

Typing math
I've added support for typesetting math using LaTeX on the forums.

Example:
Code: [Select]

TimeZoneOffset
Hello,

Please i need your help. I have a system that users can use to punch in and out. This

Guixt issue
Hello all,

We are experiencing the following problem with Guixt:

Some transact

AJAX form submit
I recently built a form that submits data to my database with an ajax function that is called throug