how to know the sec_relevant_cols [message #418728] |
Tue, 18 August 2009 06:34  |
kiranivr
Messages: 1 Registered: July 2008
|
Junior Member |
|
|
Please find the below code which gives the detailed view of sec_relevant columns.This is the example code.Some other team developed the above code and we dont have the code now and no idea on what all columns they have policy.
BEGIN
DBMS_RLS.ADD_POLICY (object_schema => 'devl_1',
object_name => 'EMP',
policy_name => 'EMP_POL',
function_schema => 'DEVL_2l',
policy_function => 'ICreate_Policy.EMP_FUNC',
Statement_types=>'select',
sec_relevant_cols => 'empid,empname');
END;
/
so where will i get the exact column names on which policy is applied.
Thanks,
kiran
|
|
|
|