-
Code:
SELECT * FROM V$PWFILE_USERS ORDER BY 1;
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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;
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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
-
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
Well, if somebody managed to get access to server OS. They can cause damage even without logging-in.
Last edited by SANJAY_G; 06-10-2003 at 04:31 AM.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|