Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with GRANT
"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