About Oracle8i stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
shyju
Participant
Posts: 58
Joined: Thu May 19, 2005 1:00 am

About Oracle8i stage

Post 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?
sudharsanan
Participant
Posts: 64
Joined: Fri Jul 16, 2004 7:53 am

Post 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
shyju
Participant
Posts: 58
Joined: Thu May 19, 2005 1:00 am

Post by shyju »

Thanx a lot Sudharsanan...
Post Reply