|
|
|
|
|
|
| Re: vpd condition with joins in DataWarehouse [message #637398 is a reply to message #637312] |
Sun, 17 May 2015 00:53   |
 |
Droryash
Messages: 3
Registered: May 2015
|
Junior Member |
|
|
O.K, But when I am in side the VPD function, How can I know that there is a join to the Fac_ table?
I'm trying :
--prev_exec_id
SELECT s.sid, s.username, sa.sql_text
FROM v$session s
JOIN v$session SS
ON ss.prev_exec_id = s.sql_exec_id
JOIN v$sql sa
ON s.sql_address = sa.address
AND s.sql_hash_value = sa.hash_value
WHERE s.schema# NOT IN (0, 24) --not sys
AND ss.audsid = SYS_CONTEXT('USERENV', 'SESSIONID') --MYSELF;
[Updated on: Sun, 17 May 2015 10:38] Report message to a moderator |
|
|
|
|
|
|
|
| Re: vpd condition with joins in DataWarehouse [message #637440 is a reply to message #637430] |
Mon, 18 May 2015 00:55 |
|
Droryash
Messages: 3
Registered: May 2015
|
Junior Member |
|
|
In DATA WHAREHOUSE the users builds the query. So There is endless possibilities of how the query will look like.
In view we resolve only one specipic query, So it's not good enough.
What I need is to know weather there is a join with the prefix <FACT_...> in one if the tables.
and all this in side the vpd function (in the same session)
ex:
SELECT *
FROM dim_1 JOIN fact_1
ON dim_1.no = fact_1.no
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
