Home » RDBMS Server » Security » how to enforce oracle password special character (RDBMS. 11.2.0.3 , LINUX)
how to enforce oracle password special character [message #625400] Tue, 07 October 2014 14:21 Go to next message
evoradba
Messages: 111
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
Re: how to enforce oracle password special character [message #625401 is a reply to message #625400] Tue, 07 October 2014 14:27 Go to previous messageGo to next message
John Watson
Messages: 7933
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.
Re: how to enforce oracle password special character [message #625405 is a reply to message #625400] Tue, 07 October 2014 14:56 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
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.

Re: how to enforce oracle password special character [message #625408 is a reply to message #625401] Tue, 07 October 2014 15:30 Go to previous message
evoradba
Messages: 111
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
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:
  


Current Time: Mon Jun 17 15:41:35 CDT 2019