Re: How do you tell if a user account is in the grace period ?

Richard Elliott wrote:

> Need to be able to tell from a Power Builder client if the user is
> still in the grace period when the account has expired ?
>
> Don't see any flag in any of the user tables ?
>
> Thanks in advance for the help.

SQL> desc dba_users

  Name                                      Null?    Type
  ----------------------------------------- -------- 
----------------------------
  USERNAME                                  NOT NULL VARCHAR2(30)
  USER_ID                                   NOT NULL NUMBER
  PASSWORD                                           VARCHAR2(30)
  ACCOUNT_STATUS                            NOT NULL VARCHAR2(32)
  LOCK_DATE                                          DATE
  EXPIRY_DATE                                        DATE
  DEFAULT_TABLESPACE                        NOT NULL VARCHAR2(30)
  TEMPORARY_TABLESPACE                      NOT NULL VARCHAR2(30)
  CREATED                                   NOT NULL DATE
  PROFILE                                   NOT NULL VARCHAR2(30)
  INITIAL_RSRC_CONSUMER_GROUP                        VARCHAR2(30)
  EXTERNAL_NAME                                      VARCHAR2(4000)

But would help would that be, when the account is expired? The server will initiate a "change your password" dialog - can you handle that?

-- 

Regards,
Frank van Bortel