Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: perl connection "/ as sysdba" doesn't work for me on solaris

Re: perl connection "/ as sysdba" doesn't work for me on solaris

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 31 Aug 2006 10:01:17 +0200
Message-ID: <bo5df21tfhikqsme46m8437ul77merq9og@4ax.com>


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 DBA
Received on Thu Aug 31 2006 - 03:01:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US