Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ORA-06512 "SYS.DBMS_NETWORK_ACL_ADMIN" while trying to create new ACL

M.EmmanuelAug 24 2016 — edited Aug 25 2016

Hi, I am trying to create a new ACL in Oracle 11g Release 2.

SQL> connect SYS as SYSDBA

SQL> begin

        dbms_network_acl_admin.create_acl (

                acl => 'webservices.xml',

                description => 'HTTP Access',

                principal => 'MYUSER',

                is_grant => TRUE,

                privilege => 'connect',

                start_date => null,

                end_date => null

        );

end;

  2    3    4    5    6    7    8    9   10   11   12

13  /

begin

*

ERROR at line 1:

ORA-00904: : invalid identifier

ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 252

ORA-06512: at line 2

MYUSER can be found while doing "select username from dba_users;"

Any help or tip is welcomed.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2016
Added on Aug 24 2016
13 comments
2,916 views