Home » RDBMS Server » Security » regarding profiles
regarding profiles [message #23043] Thu, 14 November 2002 01:27 Go to next message
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 Go to previous message
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
Previous Topic: SECURITY on PUBLIC GRANTEES (Urgent)
Next Topic: regarding roles
Goto Forum:
  


Current Time: Tue Oct 26 07:20:54 CDT 2021