Home » RDBMS Server » Security » Password verifiy function while creating a profile (oracle 10g)
Password verifiy function while creating a profile [message #534277] Mon, 05 December 2011 00:40 Go to next message
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
Re: Password verifiy function while creating a profile [message #534279 is a reply to message #534277] Mon, 05 December 2011 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I've created a password verification function (verify_pwd) in a schema which is not in SYS, but an equivalent of SYS.

1/ It MUST be in SYS
2/ There is NO equivalent to SYS, SYS is unique

Regards
Michel
Re: Password verifiy function while creating a profile [message #534284 is a reply to message #534279] Mon, 05 December 2011 01:37 Go to previous messageGo to next message
amlesh
Messages: 2
Registered: December 2011
Location: Mauritius
Junior Member
Thanks Michel,

One more thing :

Is it not possible even if I create a user, granting it with SYSDBA and SYSOPER?

Rgds,

DjB
Re: Password verifiy function while creating a profile [message #534287 is a reply to message #534284] Mon, 05 December 2011 01:49 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Previous Topic: User Password Expired
Next Topic: Design question regarding security
Goto Forum:
  


Current Time: Thu Mar 28 07:56:58 CDT 2024