Page 1 of 1

About Oracle8i stage

Posted: Wed Jun 08, 2005 12:23 am
by shyju
Hi all,

There is an option in Oracle8i stage called "Use OS level authentication". When i looked in the DataStage help, it says to automatically log on using operating system user name and password.
My question is how does it gets logged on to oracle database just by providing OS user id and passdword?

Posted: Wed Jun 08, 2005 12:52 am
by sudharsanan
Hi Shyju,

You have asked about Oracle8i stage with "Use OS level authentication" option.. This option is avaliable at the database level. In oracle you can log in to the database with the OS user ID..This option is set by the Oracle DBA while creating the database...if you want how oracle picks this user then probably you can ask your Oracle DBA.. probably he can provide more info on this...utimatley this option makes it easier to log on to Databases with OS user ID itself ....i hope this info is useful to you...

Thanks
Sudharsanan A N

Posted: Wed Jun 08, 2005 2:28 am
by shyju
Thanx a lot Sudharsanan...