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

Thread: password for user

  1. #1
    Join Date
    May 2001
    Posts
    736
    Hello friends
    since the OS authentication problem is not yet solved on my system so in mean time iam planning to create users with password.My OS Win2000 and Oracle 8i.just like in OS how to create a user with a profile so that at first logon he need to change password .Can any one list the details.All the remarks are appreciated.
    regards
    akhadar

  2. #2
    Join Date
    Oct 2000
    Posts
    467
    create user username
    identified by password
    password expire;
    Vinit

  3. #3
    Join Date
    May 2001
    Posts
    736
    Hello vinit
    when i did this on the profile the user still able to login with the password supplied by me only. Oracle is prompting him to change the password .since in profile under expire password there are only two options 1)expire in
    2)lock. I gave the option default.
    regards
    akhadar

  4. #4
    Join Date
    May 2001
    Posts
    736
    just now i got the solution.After login with the password supplied by me,after typing the word PASSWORD at sql prompt Oracle is asking the user to change the password.Now the user is authorised to change the password.Is it same procedure.Any one who is following the password convention can give their remarks.
    Thanks to all
    regards
    akhadar

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