| regarding profiles [message #23043] |
Thu, 14 November 2002 01:27  |
sha
Messages: 84
Registered: July 2002
|
Member |
|
|
Hi,
When I create a user with same username and password then it should show error.
So I created a profile for it.
CREATE PROFILE prof LIMIT
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LIFE_TIME 60
PASSWORD_REUSE_MAX 60
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_VERIFY_FUNCTION Default
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 10
Then I created user as
CREATE USER userscott IDENTIFIED BY userscott PROFILE prof;
still the user is created.I am not getting error.
Can anbody explain all the parameters of a profile clearly.I mean each use of profile's parameters or arguments.
regards,
shastri
|
|
|
|
| Re: regarding profiles [message #23045 is a reply to message #23043] |
Thu, 14 November 2002 05:14  |
F. Tollenaar
Messages: 64
Registered: November 2002
|
Member |
|
|
Check if there is a function SYS.VERIFY_FUNCTION
(in 8i, not sure about 9i)
Make sure you runned utlpwdmg.sql in <oracle_home>/rdbms/admin (in 8.1.7 as SYS).
This creates the function verify_function.
before running it i got the same result as you, after running it, i got the desired result.
hth,
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
