Home » Other » General » Profile error (Oracle 10g)
Profile error [message #430251] Mon, 09 November 2009 14:52 Go to next message
dimasd
Messages: 1
Registered: November 2009
Location: Laurel., Maryland
Junior Member
Hello all,

I tried to create a profile as see below but had error:

create profile app_user limit
idle_time 10
password_grace_time 2
password_life_time 7
password_reuse_time 2
failed_login_attempts 3
sessions_per_user 2
password_reuse_max 2
password_lock_time 1/1440*10
connect_time 480
password_verify-function verify function;

password_verify-function verify function
*
ERROR at line 11:
ORA-02376: invalid or redundant resource

I removed d password_verify_function then it worked:
1 create profile app_user limit
2 idle_time 10
3 password_grace_time 2
4 password_life_time 7
5 password_reuse_time 2
6 failed_login_attempts 3
7 sessions_per_user 2
8 password_reuse_max 2
9 password_lock_time 1/1440*10
10* connect_time 480
SQL> /

Profile created.

I now try to put back the verify+function but found errors:


1 alter profile app_user limit
2* password_verify_function verify_function
SQL> /
alter profile app_user limit
*
ERROR at line 1:
ORA-07443: function VERIFY_FUNCTION not found

How can I create a profilw with all the papameters I want including password_verify_function?
Re: Profile error [message #430257 is a reply to message #430251] Mon, 09 November 2009 15:27 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
dimasd wrote on Mon, 09 November 2009 15:52

password_verify-function verify function;

password_verify-function verify function
*
ERROR at line 11:
ORA-02376: invalid or redundant resource


The dash should be an underscore. And you do know that what comes after this is an actual function name (you have so many typos I cannot tell if you are typing invalid commands or just making typos). By default, I do not think the function verify_function exists in the database. You can ask your DBA. It's in the script utlpwdmg.sql

[Updated on: Mon, 09 November 2009 15:53]

Report message to a moderator

Previous Topic: REDO Logs not wanted
Next Topic: Peformance Log and Alerts
Goto Forum:
  


Current Time: Thu Mar 28 16:19:48 CDT 2024