Code:SELECT * FROM V$PWFILE_USERS ORDER BY 1;
Printable View
Code:SELECT * FROM V$PWFILE_USERS ORDER BY 1;
Thanks Sanjay,
The query fixed.
The second question as mentioned :
How to use sqlplus test/test@sid from the same server or from another server running oracle for instance running scripts as sysdba.
using sqlplus test/test@sid is not possible.
Do you know how to fix such kind of authentication.
//Hamhey
Code:grant connect, resource to test;
Thanks Sanjay,
fixed.
My last wondering:
Of security reason you should remove the possibility to inhibit users to become sysdba
by using:
sqlplus scott/tiger
sQL>connect / as sysdba
When they have access to the server.
//Hamhey
Well, if somebody managed to get access to server OS. They can cause damage even without logging-in.Quote:
Originally posted by hamhey
Thanks Sanjay,
fixed.
My last wondering:
Of security reason you should remove the possibility to inhibit users to become sysdba
by using:
sqlplus scott/tiger
sQL>connect / as sysdba
When they have access to the server.
//Hamhey