Home » RDBMS Server » Security » how to know the sec_relevant_cols (VPD POLICY -SECURITY)
how to know the sec_relevant_cols [message #418728] Tue, 18 August 2009 06:34 Go to next message
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
Re: how to know the sec_relevant_cols [message #418731 is a reply to message #418728] Tue, 18 August 2009 07:07 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_policies

Regards
Michel
Previous Topic: Enterprise User/Role
Next Topic: How to authenticate a user by OS
Goto Forum:
  


Current Time: Thu Mar 28 18:39:36 CDT 2024