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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with GRANT

Re: Problem with GRANT

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 19 Apr 2004 15:36:35 +0100
Message-ID: <4083e3f3$0$25242$ed9e5944@reading.news.pipex.net>


"termoPilucco" <termop3141927_at_hotmail.com> wrote in message news:c60is5$6koqk$1_at_ID-188026.news.uni-berlin.de...
> "Niall Litchfield" ha scritto:
>
> [...]
> > connect as anag in your script?
>
> Thanks for replying.
> Yes, it seems a good idea but my program has to create the script without
> knowing 'system' password (a DBA will check launch my script using
'system'
> login and password ).
> So, once connected as 'ANAG', can i reconnect as 'system' without having
> password?

If the script is run interactively then you can prompt for all the required inputs at the start of the script - the supplied 9i sample schemas do exactly this.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/
Received on Mon Apr 19 2004 - 09:36:35 CDT

Original text of this message

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