Re: writing files by pl/sql

Alex Filonov wrote:

> DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E441C7D.2D7ECC64_at_exesolutions.com>...
> > Alex Filonov wrote:
> >
> > > DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E428C46.83307170_at_exesolutions.com>...
> > > > Oliver Stratmann wrote:
> > > >
> > > > > Hello All,
> > > > >
> > > > > is there another way of writing files with a pl/sql-procedure than using the
> > > > > utl_file-package?
> > > > > is there a way of writing files with a pl/sql-procedure on a client-machine?
> > > > >
> > > > > thanks in advance!
> > > > > oli
> > > >
> > > > There are other ways using C and Java.
> > > >
> > > > On the client? Undoubtedly if you wrap your own in C or Java but I've not seen
> > > > anyone do it. And I'd never do it as it could be a huge security violation
> > > > allowing data to walk out the door in diskette.
> > >
> > > Sorry, if data is available on the client machine (isn't it a goal of
> > > client-server applications?) you can always cut and paste it to some
> > > file, which can be then copied to diskette... :)
> > >
> > > There is no such thing as absolute security. And before you define
> > > hardware/software security procedures, you need to determine which
> > > people have access to which data. If you don't trust people, they
> > > have no right to access data in any form, period.
> > >
> > > >
> > > > Daniel Morgan
> >
> > One can always violate security one record field at a time. But there is a huge difference between cut
> > and paste and SELECT * FROM ...
> >

>

No please tell me about them.

Seriously ... of course. But reports are not data dumps unless someone is horribly confused about the purpose of a report. I've yet to see a report on a 500GB data warehouse that run the query SELECT * FROM ... though I've no doubt someone has implemented it somewhere.

Daniel Morgan Received on Tue Feb 11 2003 - 17:45:54 CET