Re: External tables. Security concerns.

Sybrand Bakker wrote:
> On 18 Aug 2006 14:01:10 -0700, artmt_at_hotmail.com wrote:
>
> >> Yes and no. they are correct to not allow uncontrolled use of UTL_FILE
> >> but directory objects are harmless and the only real risk with an
> >> External Table would be you dumping GB of into a file and using too
> >> much disk.
> >>
> >> Most likely they don't understand the technology because if they did
> >> they would know that DIRECTORY OBJECTS are wholly internal to the
> >> database.
> >> --
> >> Daniel A. Morgan
> >> University of Washington
> >> damorgan_at_x.washington.edu
> >> (replace x with u to respond)
> >> Puget Sound Oracle Users Group
> >> www.psoug.org
> >
> >That answers my question about external tables.
> >Thanks.
> >How about the other components required to implement ETL via external
> >tables?
> >Would allowing FTP access or NFS mount necessarily jeopardize secutity
> >of the Oracle server?
>
> ordinary ftp would definitely jeopardize security, and shouldn't be
> considered.
> I also wouldn't consider a NFS mount to the Oracle server.

What would you recommend instead? Received on Sat Aug 19 2006 - 09:20:10 CDT