Re: How to restrict connections but allow export

From: Tech Geek <Tech_Geek_at_gawab-IHateSpam.com>
Date: Mon, 29 Dec 2003 00:49:34 GMT
Message-ID: <ySKHb.5416$E17.4657@nwrddc02.gnilink.net>

Hi Rick,
"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:v7suuvcqg3dsi90npigibvrb95q1bp6b68_at_4ax.com...
> If a to a "startup restrict" in order to avoid connections and keep
> the DB in a specific state for full export, the export fails. The exp
> utility does not seem to use connections as sysdba.
>
> What can I do to allow export to take place while the system is in
> restricted mode?
>
> Thanks
>
> Rick Denoire
>
> PS:
> Other ideas:
> a) shutdown the listener and start the exp on the DB host?
> b) set the DB readonly? (won't probably work as desired)
>

How about granting "Restricted Session" privilege to the user who is performing exports?

HTH Received on Sun Dec 28 2003 - 18:49:34 CST