XML Database (MOSC)

MOSC Banner

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL didn't create xml in /sys/acls

edited Nov 19, 2010 5:50AM in XML Database (MOSC) 6 commentsAnswered
 Hi,

I upgraded my 10.2.0.3 database to 11.2.0.1 on Linux 86_64.

Then I created the acls following http://download.oracle.com/docs/cd/E11882_01/network.112/e16543/authorization.htm#CIHHEGHJ Example 4-19

-- 1. Create the access control list, which includes one role and connect to one host
BEGIN
 DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
  acl          => 'xtime-xtapp-permissions.xml',
  description  => 'Network connection permission for role xtapp',
  principal    => 'XTAPP', -- Must be in upper case
  is_grant     => TRUE,
  privilege    => 'connect');
END;
/


-- 2. Assign the access control list a network host:
BEGIN
 DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
  acl         => 'xtime-xtapp-permissions.xml',
  host        => 'sternum.xtime.com',  
  lower_port  => 25, 

  upper_port  => 80);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center