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...
Did you know?Explore Trending and Topic pages for more stories like this.

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

storing video files into mysql in php
hi

i have my video files in my folder ,
i have to store the path of the videos into db an

What's wrong with my code
sobbing for many days, still don't know why please Help. Why my page isn't posted correctly. In a

PHP form authentication
Hi guys,

what am trying to achieve is this: Whenever a user tries to login to my website, an

PHP mail() with images
I'm trying to get images to send along with my HTML e-mail sent through PHP mail(). I only tried vie

storing results of a function - previous result overwritten with new result
I have created a function to validate input.

function validate_dimension($value,$name) {
<

How to use Substr
I want to check for the word CATEGORY: inside a string which can be CATEGORY: ITEM
and remove the

Multiple submit forms inside a mysql array page
Hi all,

Im having trouble to get the beneath script to work the thing i can't seem to get wor

Display thumbnails as square while retaining aspect ratio
I am trying to figure out a way to make an image display as a square, for example 80x80 pixels, when

PHP arrays into arrays need help
Hello
I am trying to highlight the days on my calendar based on the dates that i have in my datab

Gantt Chart Tool
Does anyone know of a good free gantt chart creator tool

Thanks

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