Re: remote OS authentication?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 2 Aug 2002 06:10:24 +0200
Message-ID: <ukk2dr5tg0ic5d@corp.supernews.com>

comments embedded

"Ed Wong" <ewong_at_mail.com> wrote in message news:a5ae1554.0208011526.654a634a_at_posting.google.com...
> If I set REMOTE_LOGIN_PASSWORDFILE to NONE, I can get the OS
> Authentication and logon LOCALLY on server as "connect / as sysdba" as
> long as I am in oracle dba group. Can I do the same thing remotely
> from other server?

NO, and that is good.

For example, can I do "connect /@proddb as sysdba"
> from other server?
>
> I know that if I set the password file with REMOTE_LOGIN_PASSWORDFILE
> = EXCLUSIVE, I can do "connect scott/tiger_at_prodb as sysdba". But I
> don't want to specify username/password as I am implementing some
> remote scripts and I don't want to put username/password in the
> script.
>
> I am using Oracle 8.1.7EE on Sun Solaris 2.7
>
> Thanks,
> ewong

Why on earth do you need SYSDBA running remote scripts? I would recommend finding out how Oracle security really works, you are currently heading for disaster as you say you completely want to *unsecure* your database.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Thu Aug 01 2002 - 23:10:24 CDT