DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: passwordfile

  1. 04-29-2003, 06:23 AM #1
    ser
    ser is offline Junior Member
    Join Date
    Apr 2003
    Posts
    46

    passwordfile

    orapwd utility allows us to create a passwordfile . how would i link or associate users in this file. or how would i add the users password to this file.
    Reply With Quote Reply With Quote
  2. 04-29-2003, 06:27 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Code:
    GRANT SYSDBA TO user;
    Will add them to the password file.

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 04-29-2003, 06:32 AM #3
    shandj
    shandj is offline Junior Member
    Join Date
    Feb 2002
    Posts
    70
    By granting SYSDBA or SYSOPER to the users.

    Before that in your Init.ora file, you have to set REMOTE_LOGIN_PASSWORD= EXCLUSIVE. otherwise, you will get error while granting sysdba or sysoper to the users.

    Check the v$pwfile_users view to find which user is having sysdba or sysoper system privileges.

    Thanks,
    ________________
    ShanDJ
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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