Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: determine value of password_lock_time

Re: determine value of password_lock_time

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Thu, 20 Nov 2003 23:12:04 +0100
Message-ID: <30fqrvgpaustgcis6h6e48gg0l4lf69r9d@4ax.com>


On Thu, 20 Nov 2003 22:05:32 GMT, "Terry Dykstra" <dontreply_tddykstra_at_forestoil.ca.x> wrote:

>When a user gets ora-28000, is there a way to display to the user what the
>value of password_lock_time is?
>Using Oracle 817 SE.

As the password_lock_time is set using a profile, it should be sufficient to join dba_users and dba_profiles to arrive at the password_lock_time.

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Nov 20 2003 - 16:12:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US