We have been trying to setup this authentication without success. "We" are the report developer (that's me) and my boss who knows how to keep us secure. Our network administrator is out sick but I'm not sure he'd know where the problem is anyway.
I've developed a group of applications for which we want to use one login through our Active Directory. We've read numerous blogs, websites, and the forum itself over the last few days.
We are on Application Express 4.2.2.00.11
At Shared Components within our application I've set up the authentication scheme with the following:
Name: LDAP Login
Scheme type: LDAP Directory
Host: OURCORP.NET
Port: 389
Use SSL: No
DN String: CN=%LDAP_USER%,dc=OURCORP,dc=NET
Exact: Yes
Username Esc: Standard
When we run this within Apex
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'www.xml',
description => 'WWW ACL',
principal => 'ANAME',
is_grant => true,
privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'www.xml',
principal => 'ANAME',
is_grant => true,
privilege => 'resolve');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'www.xml',
host => 'www.us.oracle.com');
END;
We get this:
ORA-06550: line 2, column 3:
PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
ORA-06550: line 8, column 3:
PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN' must be declared
ORA-06550: line 8, column 3:
PL/SQL: Statement ignored
ORA-06550: line 13, column 3:
PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN' must be declared
ORA-06550: line 13, column 3:
PL/SQL: Statement ignored
Thank you in advance!!
Alexandra