{"id":576,"date":"2024-01-19T13:43:41","date_gmt":"2024-01-19T13:43:41","guid":{"rendered":"https:\/\/maboc.nl\/?p=576"},"modified":"2024-01-19T13:43:41","modified_gmt":"2024-01-19T13:43:41","slug":"creating-an-acl","status":"publish","type":"post","link":"https:\/\/maboc.nl\/?p=576","title":{"rendered":"Creating an ACL"},"content":{"rendered":"<p>A very simple example of creating an ACL for a principal and a host:<\/p>\n<p>Creating the ACLS (qith the associated principal) itself.<\/p>\n<pre>exec dbms_network_acl_admin.create_acl( acl=&gt;'print_permissions.xml',\r\n                                        description=&gt;'Gebruikt voor Print functionaliteit',\r\n                                        principal=&gt;'APEX_230100',\r\n                                        is_grant=&gt;TRUE,\r\n                                        privilege=&gt;'connect');<\/pre>\n<p>Associating a host to the ACL:<\/p>\n<pre>exec dbms_network_acl_admin.assign_acl( acl=&gt;'print_permissions.xml',\r\n                                        host=&gt;'machine-name.domain.domain',\r\n                                        lower_port=&gt;8010, upper_port=&gt;8010);\r\n\r\n<\/pre>\n<p>This is a starting point. You can go from here &#8230;<\/p>\n<p>(for security reasons I altered some fields)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A very simple example of creating an ACL for a principal and a host: Creating the ACLS (qith the associated principal) itself. exec dbms_network_acl_admin.create_acl( acl=&gt;&#8217;print_permissions.xml&#8217;, description=&gt;&#8217;Gebruikt voor Print functionaliteit&#8217;, principal=&gt;&#8217;APEX_230100&#8242;, is_grant=&gt;TRUE, privilege=&gt;&#8217;connect&#8217;); Associating a host to the ACL: exec dbms_network_acl_admin.assign_acl( acl=&gt;&#8217;print_permissions.xml&#8217;, host=&gt;&#8217;machine-name.domain.domain&#8217;, lower_port=&gt;8010, upper_port=&gt;8010); This is a starting point. You can go from here &#8230; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,28,49],"tags":[95,24,29,14],"class_list":["post-576","post","type-post","status-publish","format-standard","hentry","category-oracle","category-security","category-sql","tag-acl","tag-oracle","tag-security","tag-sql"],"_links":{"self":[{"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/posts\/576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maboc.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=576"}],"version-history":[{"count":1,"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/posts\/576\/revisions"}],"predecessor-version":[{"id":577,"href":"https:\/\/maboc.nl\/index.php?rest_route=\/wp\/v2\/posts\/576\/revisions\/577"}],"wp:attachment":[{"href":"https:\/\/maboc.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maboc.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maboc.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}