| Password verifiy function while creating a profile [message #534277] |
Mon, 05 December 2011 00:40  |
 |
amlesh
Messages: 2
Registered: December 2011
Location: Mauritius
|
Junior Member |
|
|
Hello friends,
I've created a password verification function (verify_pwd) in a schema which is not in SYS, but an equivalent of SYS.
However, the problem arises when I'm trying to create a profie (MAIN_PROFILE) with the following attributes :
CREATE PROFILE MAIN_PROFILE LIMIT
PASSWORD_LIFE_TIME 90
PASSWORD_VERIFY_FUNCTION verify_pwd;
The above script is resulting in an error.
ORA-02376 : invalid or redundant resource
Can I create the function verify_pwd not in the schema SYS but instead in a schema equivalent to SYS?
Please advise.
Rgds,
DjB
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
