DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Oracle Pawword file

  1. #11
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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"

  2. #12
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94
    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

  3. #13
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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"

  4. #14
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94
    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

  5. #15
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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
  •  


Click Here to Expand Forum to Full Width