create or replace function sys.student_pwd_verify_function(username     varchar2
                                                          ,password     varchar2
                                                          ,old_password varchar2)
  return boolean is
begin
  return password like '%#%' and lower(password) != lower(username);
end;
/
grant execute on sys.student_pwd_verify_function to public;

create profile student_profile
limit password_verify_function
student_pwd_verify_function container = current;

create user ivanov
identified by ivanov#
default tablespace users
temporary tablespace temp
profile student_profile;