verification for more information for 18c

verification for more information for 18c

password complexity checking. in a default installation, oracle database 
provides the ora12c_verify_function and ora12c_strong_verify_function password verification functions 
to ensure that new or changed passwords are sufficiently complex to prevent intruders who try 
to break into the system by guessing passwords. you must manually enable password complexity checking. 
you can further customize the complexity of your users' passwords. see about password complexity 
verification for more information.
 
verify_function_11g function password requirements:  < <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
the verify_function_11g function originated in oracle database release 11g.
 
ora12c_verify_function password requirements:        <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
the ora12c_verify_function function fulfills the department of defense database security technical 
implementation guide requirements.
 
 
----database selecting  from cdb
sql> set linesize 200
sql> col owner for a10
sql> col object_name for a35
sql> col object_type for a15
sql> select owner,object_name,object_type,status,sharing from dba_objects where object_name like '%verify_function%';
owner      object_name                         object_type     status  sharing
---------- ----------------------------------- --------------- ------- ------------------
sys        ora12c_verify_function              function        valid   metadata link
sys        verify_function_11g                 function        valid   metadata link
sys        verify_function                     function        valid   metadata link
sys        ora12c_strong_verify_function       function        valid   metadata link
sys        ora12c_stig_verify_function         function        valid   metadata link
sql> 
 
 
sql> create pluggable database pdb1 admin user pdbuser identified by pdbuser;
pluggable database created.
sql> alter pluggable database pdb1 open;
pluggable database altered.
sql> alter session set container=pdb1;
session altered.
sql> set linesize 200
sql> col owner for a10
sql> col object_name for a35
sql> col object_type for a15
sql> select owner,object_name,object_type,status,sharing from dba_objects where object_name like '%verify_function%';
 
owner      object_name                         object_type     status  sharing
---------- ----------------------------------- --------------- ------- ------------------
sys        ora12c_verify_function              function        valid   metadata link
sys        verify_function_11g                 function        valid   metadata link
sys        verify_function                     function        valid   metadata link
sys        ora12c_strong_verify_function       function        valid   metadata link
sys        ora12c_stig_verify_function         function        valid   metadata link
sql> show pdbs         
    con_id con_name                       open mode  restricted
---------- ------------------------------ ---------- ----------
         4 pdb1                           read write no
sql> 
 
--modify the function in cdb and check in pdb
create or replace noneditionable function verify_function_11g
(username varchar2,
 password varchar2,
 old_password varchar2)
return boolean is
   differ integer;
   db_name varchar2(40);
   i integer;
   i_char varchar2(10);
   simple_password varchar2(10);
   reverse_user dbms_id;
   canon_username dbms_id := username;
begin
   return(true);
end;
This entry was posted in 18c. Bookmark the permalink.