Home » RDBMS Server » Security » External users and ORA-01017
External users and ORA-01017 [message #158554] Mon, 13 February 2006 02:42
landini
Messages: 2
Registered: February 2006
Junior Member
I have set up an Oracle 9.2 database on a HP-UX system and I plan to use external user authentication.

In the init.ora file I have set the following parameters:
os_authent_prefix = ''
remote_os_authent = 'TRUE'

I have created a user with the following statement

CREATE USER HPSIC IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE HPSIC_DATA
TEMPORARY TABLESPACE TEMPTBS
QUOTA UNLIMITED ON HPSIC_IDX
QUOTA UNLIMITED ON HPSIC_DATA;

GRANT DBA TO HPSIC

I try to connect using ODBC or Enterprise Manager Console from a Windows XP system.

In the tnsnames.ora I have the following configuration
TESTSIC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hpsicmi05.italy.hp.com)(PORT = 1521))
)
(CONNECT_DATA =
(SID = testsic)
(SERVER = DEDICATED)
)
)

In sqlnet.ora there are the following data
NAMES.DEFAULT_DOMAIN = emea.cpqcorp.net
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

When I log on the Unix system using HPSIC and I issue SQLPLUS /, everything works. When I connect from Windows XP, I get the following message ORA-01017: invalid username/password; logon denied.
Everything works using a local Oracle account, for example SYSTEM.

Any suggestions are appriciated.
Thanks,

Marta

Previous Topic: Oracle DBMS – Critical Access Control Bypass in Login Bug
Next Topic: Problem with aud$ table
Goto Forum:
  


Current Time: Fri Mar 29 01:51:10 CDT 2024