Database Security Products (MOSC)

MOSC Banner

Database Password Security

edited Feb 2, 2011 6:30AM in Database Security Products (MOSC) 12 commentsAnswered
10.2.0.4 database.

 I have a PROFILE setup to manage some user accounts.  The profile is defined to expire the password in 60 days.  A recent query shows some of the accounts with passwords older than 60 days. 

I am using the VERIFY_FUNCTION to handle the some password security. 

Need to know if there is something else im missing that may be superseding the password age I have defined.

VERIFY_FUNCTION

CREATE OR REPLACE FUNCTION verify_function
(username varchar2,
  password varchar2,
  old_password varchar2)
  RETURN boolean IS
   n boolean;
   m integer;
   differ integer;
   isdigit boolean;
   ischar  boolean;
   ispunct boolean;
   digitarray varchar2(20);
   punctarray varchar2(25);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center