Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 691
  • Last Modified:

Oracle Apex ACL

I want to allow an apex application to access a json feed via UTL_HTTP from outside my network.

I currently get.

acl
How can i get around this?  who would be the principal? APEX_040000? APEX_PUBLIC_USERS?
0
FutureDBA-
Asked:
FutureDBA-
  • 3
  • 3
1 Solution
 
FutureDBA-Author Commented:
or better yet,

Who can i create an ACL for user Anonymous to have access to a specific hostname.
0
 
sdstuberCommented:
I wrote an article that shows how to create and maintain ACLs

http://www.experts-exchange.com/Database/Oracle/A_8429-How-to-use-Access-Control-Lists-in-Oracle.html


BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl(
            acl           => 'yourACL.xml',
            description   => 'your apex acl',
            principal     => 'ANONYMOUS',
            is_grant      => TRUE,
            privilege     => 'connect'
        );

        --- resolve might be optional for your use
        DBMS_NETWORK_ACL_ADMIN.add_privilege(
            acl         => 'yourACL.xml',
            principal   => 'ANONYMOUS',
            is_grant    => TRUE,
            privilege   => 'resolve'
        );

        --Assign these privileges to all hosts and all ports
        -- You can change the * to a specific host or set of hosts
        DBMS_NETWORK_ACL_ADMIN.assign_acl('yourACL.xml', '*');
        COMMIT;
end;


In your case though I think you want put the APEX schema as the principal, rather than ANONYMOUS.

Check the installation guide under "Enable Network Services"
0
 
FutureDBA-Author Commented:
when you say apex schema.

Do you mean the schema I am using apex with? (in my case cdc)

or, do you mean the users

apex_040000
apex_040200
apex_public_users
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
sdstuberCommented:
I mean apex_040200

or whichever schema you're using, usually it would be the latest
0
 
FutureDBA-Author Commented:
I've created the schema, i still cannot connect, oddly enough, when i run sql command from within apex, i can get the url.

please see below.


api
api
0
 
sdstuberCommented:
>>> I've created the schema, i still cannot connect


what schema did you create? How are you using this new schema in relation to this question?
Did you add your new schema as a principal to the same ACL as the apex owner?
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now