Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> OPS$USER and SYSDBA privilege

OPS$USER and SYSDBA privilege

From: Prince Kumar <gspk_at_yahoo.com>
Date: 30 Aug 2001 14:49:09 -0700
Message-ID: <629275ba.0108301349.38ec45a@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?  

(I have the remote_os_authent = true)

At local server:



Now, I granted the user "sysdba" privilege.

usr_at_dev01$ sqlplus dbausr/pwd ;

dbausr_at_dev01> create user ops$usr identified externally ;

User created.

dbausr_at_dev01> grant sysdba to ops$usr ;

Grant succeeded.

At the remote client:



[usr_at_dev03]$ sqlplus "/@dev04 as sysdba"

SQL*Plus: Release 8.1.6.0.0 - Production on Thu Aug 30 14:31:18 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Enter user-name:

But, If I try, as a normal user (no sysdba) it connects perfect. Anyidea, how to get this work?

[usr_at_dev03]$ sqlplus "/@dev04"

SQL*Plus: Release 8.1.6.0.0 - Production on Thu Aug 30 14:40:23 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production JServer Release 8.1.7.2.0 - Production

Note: I am testing various scenarios.
Listed below the init.ora parameter,

remote_login_passwordfile = exclusive

remote_os_authent = true #vulnerable to security breach, used for testing only

os_authent_prefix = "ops$" Received on Thu Aug 30 2001 - 16:49:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US