Oracle Pawword file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 15

Thread: Oracle Pawword file

Threaded View

  1. #1
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94

    Oracle Pawword file

    Hi all,
    I need to get permisson to some users to connect from the same server running the database and from another server to connect to a database as sysdba.
    What I did is:
    1. used orapwd and created a new file pwd
    2. changed the prameter remote_login_passwordfile = exclusive
    3. create users and granted sysdba and sysoper to the users
    4. SQL>connect user/password as sysdba
    is possible
    but
    -sqlplus user/password@sid is not possible

    -quering of v$pwfile_users shows no rows.

    Any idea what is missing or wrong.

    //Hamhey
    Last edited by hamhey; 06-10-2003 at 02:15 AM.

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