Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> OPS$USER and SYSDBA privilege
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:
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:
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