Re: How to restrict connections but allow export

From: Tech Geek <Tech_Geek_at_Gawab-HateSpam.com>
Date: Mon, 29 Dec 2003 01:29:09 GMT
Message-ID: <FrLHb.5826$E17.4754@nwrddc02.gnilink.net>

Rick Denoire wrote:
> "Tech Geek" <Tech_Geek_at_gawab-IHateSpam.com> wrote:
>
>
>

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

>
> ´
> Fine. Who gets that privilege when the export runs like this?:
> exp "/" ....
>
> (and I don't want to put passwords in the script).
>
> Bye
> Rick Denoire
>

When you connecting as "/", means you are using OS authentication and the user who is logged on at the OS level will get the privs. In most cases it would OPS$ORACLE.

Thanks
TG Received on Sun Dec 28 2003 - 19:29:09 CST