| Profile error [message #430251] |
Mon, 09 November 2009 14:52  |
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  |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
