But an enduser has no access to dba_ views. user_users does not show the
profile as dba_users does.
Should I make a function that can read the dba_ views and then grant execute
privileges on that function to the users?
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message
news:30fqrvgpaustgcis6h6e48gg0l4lf69r9d_at_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 Fri Nov 21 2003 - 10:04:06 CST
