Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: perl connection "/ as sysdba" doesn't work for me on solaris
On Thu, 31 Aug 2006 16:13:24 +1000, Tasm <tasm_at_tasm.com> wrote:
>I'm running a perl script from the oracle account so that I can dump a large
>number of tables to flat files. Unfortunately this is required by another group
>and they must be in flat file format to their specification. Unfortunately
>there doesn't seem to be any other way to dump oracle tables quickly to flat files.
So an *ordinary* account with the SELECT ANY TABLE privilege would do, and there is NO BUSINESS CASE for compromising security and misusing SYS.
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Aug 31 2006 - 03:01:17 CDT