Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<u51g80ll7roan1b7169f74j3as327hjops_at_4ax.com>...
> On 22 Apr 2004 08:02:11 -0700, steven.fox_at_dfas.mil (Steven Fox) wrote:
>
> >I have created a test profile:
> >CREATE PROFILE "TEST_3DAYS"
> > LIMIT CPU_PER_SESSION DEFAULT CPU_PER_CALL DEFAULT
> > CONNECT_TIME DEFAULT IDLE_TIME DEFAULT SESSIONS_PER_USER
> > DEFAULT LOGICAL_READS_PER_SESSION DEFAULT
> > LOGICAL_READS_PER_CALL DEFAULT PRIVATE_SGA DEFAULT
> > COMPOSITE_LIMIT DEFAULT FAILED_LOGIN_ATTEMPTS 3
> > PASSWORD_LOCK_TIME DEFAULT PASSWORD_GRACE_TIME 3
> > PASSWORD_LIFE_TIME 3 PASSWORD_REUSE_MAX UNLIMITED
> > PASSWORD_REUSE_TIME 365 PASSWORD_VERIFY_FUNCTION
> > VERIFY_FUNCTION
> >When signing into SQLPLUS after the password expires I would expect a
> >message to change password but is recieving none.....
>
> init.ora parameter resource_limit must be set to true to check for any
> profile limit.
> Could please drop the caps and stop shouting?
it worked.... (I was not shouting but copied the profile right from oem :)
Thanks
Received on Thu Apr 22 2004 - 16:56:15 CDT
