OraFAQ Forum: Security » how to enforce oracle password special character

Home » RDBMS Server » Security » how to enforce oracle password special character (RDBMS. 11.2.0.3 , LINUX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to enforce oracle password special character [message #625400]

Tue, 07 October 2014 14:21

evoradba
Messages: 137
Registered: April 2005
Location: Canada

Senior Member

Hello
Is there a way of forcing oracle password facility to use passwords with a special character? something like only##45677.
i have modified the utlpwdmg.sql to use a password length of XXX but i would to force users to have also a special character when changing passwords
thank you

Report message to a moderator

Re: how to enforce oracle password special character [message #625401 is a reply to message #625400]

Tue, 07 October 2014 14:27

John Watson
Messages: 8805
Registered: January 2010
Location: Global Village

Senior Member

Keep modifying the script, man! Add whatever checks you want.

Or download the 12.x software, it ships with a version of utlpwdmg that includes a check for a special character.

Report message to a moderator

Re: how to enforce oracle password special character [message #625405 is a reply to message #625400]

Tue, 07 October 2014 14:56

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

11.2 standard utlpwdmg.sql checks for digits and alphabetics characters using 2 arrays, digitarray and chararray, add your own specarray and check it in the same way.

Report message to a moderator

Re: how to enforce oracle password special character [message #625408 is a reply to message #625401]

Tue, 07 October 2014 15:30

evoradba
Messages: 137
Registered: April 2005
Location: Canada

Senior Member

thanks all for the help
i have changed the utlpwdmg.sql from the 12c and modified it to my liking
thanks again

Report message to a moderator

Previous Topic:	dbms_fga.add_policy issue?
Next Topic:	Steps to configure LDAP (OID) for authentication in exiting database (11.2.0.4, RAC, ASM, RHEL 5)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 29 19:54:05 CDT 2023