Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: determine value of password_lock_time
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 DBAReceived on Thu Nov 20 2003 - 16:12:04 CST
![]() |
![]() |