OraFAQ Forum: Security » OS Authentication Followup

Home » RDBMS Server » Security » OS Authentication Followup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OS Authentication Followup [message #54815]

Fri, 06 December 2002 10:52

Sid
Messages: 38
Registered: May 1999

Member

This was a precursor to my current problem of getting OS Authentication to work with OCI.

I have been successful in getting it to work with sqlplus.

Thanks a lot to psmyth, Ravi and Helena

I wanted to test whether OS authentication works in my environment. Now that I've gotten past the initial obstacle, can someone tell me how I can get it to work with OCI?

Our program uses Oracle backend via OCI. The parameters used in our software are:
database instance, username, password.
TWO_TASK has been set to the correct database.
Should I not specify the username/pwd or should I specify them as "" or something else?

With username "sdesai" but no password:
[[ORA8_ERR #13003]]: Oracle Error: Number 1005
Message: Error while trying to retrieve text for error ORA-01005

With username "sdesai" and password "":
[[ORA8_ERR #13003]]: Oracle Error: Number 1005
Message: Error while trying to retrieve text for error ORA-01005

With no username and password:
[[ORA8_ERR #13003]]: Oracle Error: Number 1017
Message: Error while trying to retrieve text for error ORA-01017

Any help will be appreciated.

-Siddharth

Report message to a moderator

Re: OS Authentication Followup [message #54816 is a reply to message #54815]

Fri, 06 December 2002 11:41

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Verify that the OCISessionBegin() call correctly
specifies OCI_CRED_EXT  attribute as its fourth
parameter.  In the case of OCI8 for OCISessionBegin
(*svchp,*errhp,*usrhp,credt,mode), credt specifies the 
type of credentials being used to establish the user 
session. Use OCI_CRED_EXT when authenticating using 
external credentials.

Report message to a moderator

Re: OS Authentication Followup [message #54818 is a reply to message #54815]

Sat, 07 December 2002 00:03

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

okie.
then i beleive, u have change OCI options only.
I asked to check whether if u can connect via sqlplus becuase, if u cannot do that, there are many other settings, we need to look into (like NLS parameters etc, TWO_TASK etc).
that is not your case now.
the only option i know is to change the OCI setting in your CODE.

Report message to a moderator

Previous Topic:	DBMS_OBFUSCATION_TOOLKIT not present !
Next Topic:	forgot password

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 11:49:03 CST 2025