2920f4d016
Replaced Access_Controls with APEX_AUTHORISATION Created POSTCODES, ERROR_LOGS and SYSTEM_CONFIGURATION. Added missing columns to ENQUIRIES, REGULATORS, etc. Added views V_PROFILE_RT_CODE_FOR_ENRO.vw, V_PARTY_RELATIONSHIPS.vw, V_LATEST_RT_CODE_FOR_ENRO.vw. Modules: Added cout_err.pck, cout_system_configuration.pck. Data: Added Data/Demo files Added Data/Seed files for postcodes, regions and DatabaseItemToFunctionalSpecificationReference.csv Documentation: Added Documentation/pldoc for plsqldoc-generated files. Added Documentation/SupportingDocumentation/Regions to hold region definition information. git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2890 248e525c-4dfb-0310-94bc-949c084e9493
22 lines
434 B
SQL
22 lines
434 B
SQL
DECLARE
|
|
l_hash varchar2(240);
|
|
BEGIN
|
|
FOR l_pwd IN (SELECT id, username
|
|
FROM parties
|
|
WHERE username IS NOT NULL) LOOP
|
|
|
|
l_hash := mip_security.get_hash(p_username=>l_pwd.username, p_password=>'password');
|
|
|
|
INSERT INTO passwords
|
|
(prty_id
|
|
,password_hash
|
|
,created_on)
|
|
VALUES
|
|
(l_pwd.id
|
|
,l_hash
|
|
,SYSDATE);
|
|
END LOOP;
|
|
END;
|
|
/
|
|
exit
|