tag:blogger.com,1999:blog-5237676719536842801.post2771282445914162016..comments2024-03-28T08:25:10.999+04:00Comments on Dive in Oracle: Oracle Virtual Private DatabaseMahmoud A. Elsayedhttp://www.blogger.com/profile/11349719211814162336noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5237676719536842801.post-55786455175467325162012-11-04T14:15:50.183+04:002012-11-04T14:15:50.183+04:00hi i am karuna nidhan and working on a database se...hi i am karuna nidhan and working on a database security project <br /><br /><br />i want to knw that suppose we hav some stored procedure which i want to execute inside fuction of virtual private database i am giving the program down here plz state me is it the correct way because i am not getting the answer. here hii is the procedure as it is not giving error in creating the policy function.<br /><br />begin<br />dbms_rls.add_policy<br />(<br /> object_schema=>'karuna',<br /> object_name=>'sells12',<br /> policy_name=>'algorithmA12',<br /> policy_function=>'implA12',<br /> statement_types=>'select'<br />);<br />end;<br />/<br /><br /><br />create or replace function implA12<br /> (<br /> p_schema in varchar2 default null,<br /> p_object in varchar2 default null<br /> )<br />return varchar2<br />as<br />temp1 number;<br />begin<br />exec hii;<br />return 'item_id!=5';<br />end;<br />/<br /><br /><br />my id is k.nidhan854@gmail.comkarunahttps://www.blogger.com/profile/08236074128722025934noreply@blogger.comtag:blogger.com,1999:blog-5237676719536842801.post-56471843726099128212012-11-04T14:15:00.917+04:002012-11-04T14:15:00.917+04:00hi i am karuna nidhan and working on a database se...hi i am karuna nidhan and working on a database security project <br /><br /><br />i want to knw that suppose we hav some stored procedure which i want to execute inside fuction of virtual private database i am giving the program down here plz state me is it the correct way because i am not getting the answer. here hii is the procedure as it is not giving error in creating the policy function.<br /><br />begin<br />dbms_rls.add_policy<br />(<br /> object_schema=>'karuna',<br /> object_name=>'sells12',<br /> policy_name=>'algorithmA12',<br /> policy_function=>'implA12',<br /> statement_types=>'select'<br />);<br />end;<br />/<br /><br /><br />create or replace function implA12<br /> (<br /> p_schema in varchar2 default null,<br /> p_object in varchar2 default null<br /> )<br />return varchar2<br />as<br />temp1 number;<br />begin<br />exec hii;<br />return 'item_id!=5';<br />end;<br />/<br /><br /><br />my id is k.nidhan854@gmail.comkarunahttps://www.blogger.com/profile/08236074128722025934noreply@blogger.comtag:blogger.com,1999:blog-5237676719536842801.post-45531242967238190802012-06-21T21:05:14.631+04:002012-06-21T21:05:14.631+04:00This is very useful information, thanks for postin...This is very useful information, thanks for posting it, looking forward to more information on VPD on your blog.Prasad Iyernoreply@blogger.comtag:blogger.com,1999:blog-5237676719536842801.post-42694067355119804392011-07-18T19:44:01.253+04:002011-07-18T19:44:01.253+04:00I clarify in that post restricting data access in ...I clarify in that post restricting data access in VPD.<br />There is another concept is session context, I will clarify it in next post later.Mahmoud A. Elsayedhttps://www.blogger.com/profile/11349719211814162336noreply@blogger.com