{"id":1350,"date":"2018-09-25T18:19:08","date_gmt":"2018-09-25T16:19:08","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1350"},"modified":"2018-09-25T18:19:08","modified_gmt":"2018-09-25T16:19:08","slug":"moac-on-custom-table","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1350","title":{"rendered":"MOAC on custom table"},"content":{"rendered":"<p>we can register a custom table to be under MOAC control:<\/p>\n<pre>fnd_access_control_util.add_policy\r\n(p_object_schema =&gt; 'APPS'\r\n,p_object_name =&gt; 'XXDNVGL_CUSSTOMTABLE'\r\n,p_policy_name =&gt; 'ORG_SEC'\r\n,p_function_schema =&gt; 'APPS'\r\n,p_policy_function =&gt; 'MO_GLOBAL.ORG_SECURITY'\r\n,p_statement_types =&gt; 'SELECT, INSERT, UPDATE, DELETE'\r\n,p_update_check =&gt; TRUE\r\n,p_enable =&gt; TRUE\r\n,p_static_policy =&gt; FALSE);\r\nEND;<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>we can register a custom table to be under MOAC control: fnd_access_control_util.add_policy (p_object_schema =&gt; 'APPS&#8217; ,p_object_name =&gt; 'XXDNVGL_CUSSTOMTABLE&#8217; ,p_policy_name =&gt; 'ORG_SEC&#8217; ,p_function_schema =&gt; 'APPS&#8217; ,p_policy_function =&gt; 'MO_GLOBAL.ORG_SECURITY&#8217; ,p_statement_types =&gt; 'SELECT, INSERT, UPDATE, DELETE&#8217; ,p_update_check =&gt; TRUE ,p_enable =&gt; TRUE ,p_static_policy &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=1350\">Czytaj dalej <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[40],"tags":[254,256,255],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1350"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1350"}],"version-history":[{"count":1,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1350\/revisions"}],"predecessor-version":[{"id":1351,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1350\/revisions\/1351"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}