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

Thread: Password management : PASSWORD_GRACE_TIME

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    I'm testing PWD management in Ora 8i (8.1.5) running on NT4.

    I created a pwd profile and assigned it to a user (User X) when I created the user. It had all default values (as shown in DBA_PROFILES) except PASSWORD_LIFE_TIME which I set to 30. I wanted to check the expiration so I reduced this to 1 day using the ALTER PROFILE command. I did this logged in as SYSTEM.

    When I logged in as this user I got the error msg:

    ERROR:
    ORA-28002: the password will expire within 24855 days

    Ok - I hadn't set the PASSWORD_GRACE_TIME parameter. When I did set this to 5 days I still got the error message as before.

    Also - although SQL*Plus still says that I have connected (which is right, the error is only a warning of the grace period) when I issue a SHOW USER command it still shows me connected as SYSTEM - the user I was logged in as before I connected as User X.

    However - I am actually connected as User X as I have no SYSTEM privileges when I try and use them.

    I'm confused.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    That's an Oracle bug, you will find the explanation and the workaround in Metalink Note 50003.1
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Thanks Julian - I'll look into it.

    Some additional Info:

    Running a SQL*Plus report that connects as the user with the expired password
    produces errors:

    ERROR
    ORA-28002: the password will expire within 24854 days
    Connected to an idle instance.
    SP2-0642: SQL*Plus internal error state 2090, context 0:0:0
    Unsafe to proceed


    Then logging direct into SQL*Plus (SQLPLUSW.EXE)- same User Id & Pwd
    And I get...
    ERROR
    ORA-28002: the password will expire within 24854 days
    SP2-0614: Server version too low for this feature.

    (???????????????????- JM)


    Does this mean Password Profile Management is not available in 8.1.5.0.0 ?

  4. #4
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Julian,
    That note on Metalink told me nothing - it was an explanation of the Grace Period error message. Any other pointers? Whats this bug?

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I've given you wrong reference: check 75556.996
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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