ORA-02377: invalid resource limit

[M!rz@]

Dear All,

Please help for the same.

SQL> ALTER PROFILE "DEFAULT" LIMIT IDLE_TIME 15
  2  PASSWORD_LIFE_TIME 30
  3  PASSWORD_LOCK_TIME DEFAULT
  4  FAILED_LOGIN_ATTEMPTS 3;
ALTER PROFILE "DEFAULT" LIMIT IDLE_TIME 15
*
ERROR at line 1:
ORA-02377: invalid resource limit

Thanks
Mirza

[ddf]

The error is due to your attempt at modifying the DEFAULT profile,
which you cannot do. Create a NEW profile and assign that to the
users you want to restrict.

These questions you ask are nothing more than "read the manual"
questions and you should do just that -- read the manual. This group
is not your personal tutorial.


David Fitzjarrell

[Ashwani Kamboj(Dellhi)]

DEAR MIRZA

YOU ARE JUST USING DEFAULT IN PLACE OF UNLIMITED

PASSWORD_LOCK_TIME DEFAULT HERE IT SHOULD BE PASSWORD_LOCK_TIME
UNLIMITED

[ddf]

On Jun 24, 4:26 am, "Ashwani Kamboj(Dellhi)"

> > David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

Why should it be UNLIMITED if he wants to retain the default setting?
If he truly does not want to change PASSWORD_LOCK_TIME then eliminate
that from the statement:

ALTER PROFILE "DEFAULT" LIMIT IDLE_TIME 15

PASSWORD_LIFE_TIME 30
FAILED_LOGIN_ATTEMPTS 3;

I stand corrected with my original response as the above statement
does alter the DEFAULT profile settings.


David Fitzjarrell