Rick Denoire wrote:
> "Tech Geek" <Tech_Geek_at_gawab-IHateSpam.com> wrote:
>
>
>
>>How about granting "Restricted Session" privilege to the user who is
>>performing exports?
>>
>
> ´
> Fine. Who gets that privilege when the export runs like this?:
> exp "/" ....
>
> (and I don't want to put passwords in the script).
>
> Bye
> Rick Denoire
Why are you using SYS for exports? Create an OPS$ account as suggested
by Tech Geek or, assuming you have actually set up roles that reflect a
proper security heirarchy ... just remove CREATE SESSION from your base
role.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Dec 29 2003 - 10:46:56 CST
