Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creation of a Profile

572552May 10 2007 — edited May 10 2007

Hi,

I am trying to create a profile named p_prof, but iam getting 02377 error,even though i gave a valid resource limit.Can anyone solve this ?

SQL> create profile p_prof limit
2 failed_login_attempts=3,
3 password_life_time=1,
4 password_grace_time=1,
5 password_lock_time=1,
6 password_reuse_time=unlimited
failed_login_attempts=3,
*
ERROR at line 2:
ORA-02377: invalid resource limit

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2007

Added on May 10 2007

#general-database-discussions

6 comments

737 views