Home » RDBMS Server » Security » How to edit created Security Policy (Virtual Private Database) (merged 2) (Oracle11g)
How to edit created Security Policy (Virtual Private Database) (merged 2) [message #549179] Wed, 28 March 2012 07:29 Go to next message
ranamirfan
Messages: 529
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
Re: How to edit created Security Policy (Virtual Private Database) (merged 2) [message #549183 is a reply to message #549179] Wed, 28 March 2012 07:50 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
View: V$VPD_POLICY, DBA_POLICY_GROUPS, DBA_POLICY_CONTEXTS
Edit: drop and recreate.

Regards
Michel
Re: How to edit created Security Policy (Virtual Private Database) (merged 2) [message #549184 is a reply to message #549183] Wed, 28 March 2012 08:00 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Thank you.
I login as sys and view V$VPD_POLICY there is no policy with this name orders_policy.

Regards,
Irfan
Re: How to edit created Security Policy (Virtual Private Database) (merged 2) [message #549186 is a reply to message #549184] Wed, 28 March 2012 08:47 Go to previous message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe it is not in use.
I forgot DBA_POLICIES in the list, you will find it there.

Regards
Michel
Previous Topic: Grant to Select session details
Next Topic: ORA-28663
Goto Forum:
  


Current Time: Sat Dec 20 19:27:43 CST 2014

Total time taken to generate the page: 0.12243 seconds