Re: OPS$USER and SYSDBA privilege

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 31 Aug 2001 00:20:59 +0200
Message-ID: <totfbhkl7jvt39@news.demon.nl>

"Prince Kumar" <gspk_at_yahoo.com> wrote in message news:629275ba.0108301349.38ec45a_at_posting.google.com...
> I have defined an externally define user with prefix "ops$" . I am
> able to connect from the local server and remote clients. I am not
> able to connect as sysdba from the remote clients. How do I fix this?

[snip]

Your init.ora parameters are correct.
As you are trying to connect to a different server, what is the value of sqlnet.ora's parameter sqlnet.authentication_services?

Could you also check v$password_file_users (never remember where the _ are)
to check whether the grant actually succeeded. I would consider your measure however as one of the safest ways to *unsecure* your database, so you might want to reconsider.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Aug 30 2001 - 17:20:59 CDT