How to edit created Security Policy (Virtual Private Database) (merged 2) [message #549179] |
Wed, 28 March 2012 07:29 |
ranamirfan
Messages: 535 Registered: January 2006 Location: Pakistan / Saudi Arabia
|
Senior Member |
|
|
I Created the Security Policy as user sysadmin_vpd as follows
BEGIN
DBMS_RLS.ADD_POLICY (
object_schema => 'scott',
object_name => 'orders_tab',
policy_name => 'orders_policy',
function_schema => 'sysadmin_vpd',
policy_function => 'get_user_orders',
statement_types => 'select');
END;
Please let me know after creation this policy I want to view & edit them.By default where they are saved.
Regards,
Irfan
|
|
|
|
|
|