Re: Question for SQL PEOPLE.

Mohammed

> >
> Kayne,
> Method one is to use OPS$ accounts,

Will work

> Method two is to use environment variables to store the un/pwd@link,

Definitely won't work. Try it out and then do a 'ps'. You'll see what I mean.

> Method three would be *NOT* supply the un/pwd when you invoke sqlplus.

Not always possible eg in the case of a batch job.

ta
tony

--

 _____       ________ / ___|Tony Jambu, Database Consultant
  /_  _        /_ __ /     |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_( |CIS: 100250.2003_at_compuserve.com FAX: +61-3-4163559
 \_______/                 |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-4122905