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

Bar charts using Graphical Framework.
I am using Graphical Frameworks(GFW) to create a chart Graphic . There is no problem with the data d

comparing tables across databases sql refinement ideas required
Hi all

Via pl/sql I need to ensure that data between tables in different databases match

SQL Query/echo not working
Hey all,

I'm trying to run (what I thought) was a simple operation and it isn't working. I h

b+ tree
Hi
can every body help me about b+ tree ?(insert & delete)

Pulling out some result data from MYSQL
Hey Guys,

I've built a PHP page that has a for just imagine something like registration form

php wont update my db
hello,

sorry for posting in mysql forum but i dont know where exactly is the problem but here

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

printing links
Hi every1

i am connecting to a table in sql and the looping through with a while ($ var = my

Update not working ... please help
Hi,

I am trying to update a row using an edit form by passing id of the row .. but it is not

Problems with array
This code is the last lines in an upload script that uploads 4 images at the same time and writes th

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