Re: OPS$USER and SYSDBA privilege

Thank you Sybrand,

I already verified that the user is in V$PWFILE_USERS.

This is my SQLNET.ORA entry,

NAMES.DIRECTORY_PATH= (TNSNAMES) Also, I am not planning to implement this. I am just curious to try and connect this way. I read few docs abt the security vulnureblity.

Just another question on the security side. If the database is secured (behind the firewall) so that only a few other unix servers can access it (no one, other than the SYSADM can define the unix users on these client side machines), is the security breach still applicable? If so how? (explanation would be much appreciable)

Thanks,
Prince..   

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<totfbhkl7jvt39_at_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 - 21:36:31 CDT