how about os authentication ...
create user ops$oracle identified externally;
grant dba to ops$oracle;
exp / blah blah blah
hth
Deepak
- "Tatireddy, Shrinivas (MED, Keane)"
<Shrinivas.Tatireddy_at_med.ge.com> wrote:
> But (while performing exp) when we grep from os it
> will display like
>
> ps -ef |grep exp
>
> result: exp parfile=/ora8/par1
>
> so, somebody can do a more and find the password
> from the par1 file.
>
> Is there any better alternative?
>
> Thnx and regards,
> Srinivas
>
> -----Original Message-----
> Sent: Thursday, November 15, 2001 11:41 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Jack,
> I think you are referring to PARFILE...
>
>
> Suren
>
>
> -----Original Message-----
> Sent: Thursday, November 15, 2001 8:36 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hi,
>
>
> Use a controlfile.
>
>
> Jack
>
>
>
>
> "Tatireddy, Shrinivas (MED, Keane)"
> <Shrinivas.Tatireddy_at_med.ge.com>
> @fatcity.com on 15-11-2001 14:10:26
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc: (bcc: Jack van
> Zanen/nlzanen1/External/MEY/NL)
>
> Hi lists,
>
> We can see users password using
>
> ps -ef |grep sqlplus
>
> (if we run a job using sqlplus scott/tiger
> @${runfile} ).
>
> To prevent this we can run our code
>
> sqlplus -s <<EOF
> scott/tiger
> @${runfile}
> EOF
>
> Is there a similar way in export hiding the password
> (preventing users
> to see the password) . I tried it with EOF. But its
> not working.
>
> I need to setup the export in cron.
>
> can anybody through some light on this.....
>
> Thnx and regards,
> Srinivas
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tatireddy, Shrinivas (MED, Keane)
> INET: Shrinivas.Tatireddy_at_med.ge.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
>
>
>
>
> De informatie verzonden in dit e-mailbericht is
> vertrouwelijk en is
> uitsluitend bestemd voor de geadresseerde.
> Openbaarmaking,
> vermenigvuldiging, verspreiding en/of verstrekking
> van deze informatie
> aan
> derden is, behoudens voorafgaande schriftelijke
> toestemming van Ernst &
> Young, niet toegestaan. Ernst & Young staat niet in
> voor de juiste en
> volledige overbrenging van de inhoud van een
> verzonden e-mailbericht,
> noch
> voor tijdige ontvangst daarvan. Ernst & Young kan
> niet garanderen dat
> een
> verzonden e-mailbericht vrij is van virussen, noch
> dat e-mailberichten
> worden overgebracht zonder inbreuk of tussenkomst
> van onbevoegde derden.
>
> Indien bovenstaand e-mailbericht niet aan u is
> gericht, verzoeken wij u
> vriendelijk doch dringend het e-mailbericht te
> retourneren aan de
> verzender
> en het origineel en eventuele kopieën te verwijderen
> en te vernietigen.
>
> Ernst & Young hanteert bij de uitoefening van haar
> werkzaamheden
> algemene
> voorwaarden, waarin een beperking van
> aansprakelijkheid is opgenomen. De
> algemene voorwaarden worden u op verzoek kosteloos
> toegezonden.
>
> The information contained in this communication is
> confidential and is
> intended solely for the use of the individual or
> entity to whom it is
> addressed. You should not copy, disclose or
> distribute this
> communication
> without the authority of Ernst & Young. Ernst &
> Young is neither liable
> for
> the proper and complete transmission of the
> information contained in
> this
> communication nor for any delay in its receipt.
> Ernst & Young does not
> guarantee that the integrity of this communication
> has been maintained
> nor
> that the communication is free of viruses,
> interceptions or
> interference.
>
> If you are not the intended recipient of this
> communication please
> return
> the communication to the sender and delete and
> destroy all copies.
>
> In carrying out its engagements, Ernst & Young
> applies general terms and
> conditions, which contain a clause that limits its
> liability. A copy of
> these terms and conditions is available on request
> free of charge.
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: nlzanen1_at_EY.NL
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tirumala, Surendra
> INET: Surendra.Tirumala_at_am.sony.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tatireddy, Shrinivas (MED, Keane)
> INET: Shrinivas.Tatireddy_at_med.ge.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
INET: deepakthapliyal_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Nov 15 2001 - 23:32:43 CST
