Network acls problem on 11g
622743Feb 26 2008 — edited Feb 27 2008a user wanted to use utl_inaddr.get_host_name but got an error regarding network acl permissions, so I tried granting them as such:
SQL> begin
2 DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('somename.xml',
3 'somecomment',
4 'SOMEUSER', TRUE, 'connect');
5 DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('somename.xml','*');
6 end;
7 /
But I keep getting this response:
ERROR at line 1:
ORA-31003: Parent /sys/acls/ already contains child entry somename.xml
ORA-06512: at "XDB.DBMS_XDB", line 192
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 195
ORA-06512: at line 2
However, I cannot see this when I do
SQL> select * from dba_network_acls;
no rows selected
I've tried reading the docs here http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/authorization.htm#BABJJBJI
but haven't figured this out yet. I tried the dba how to see network acls thing but that also returned no rows.
I don't understand why I can't create this acl and also cannot see it.
Can anyone point me in the right direction?