spool Reset_SDMS8_schema_accounts.log

/* Remove the failed logon attempts restriction from the sdms profile. */
ALTER PROFILE SDMSPROFILE LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

/* Unlock and set the profile for three SDMS schema accounts. */
ALTER USER NGPROXY ACCOUNT UNLOCK;
ALTER USER NGPROXY PROFILE SDMSPROFILE;

ALTER USER NGSTATICUSER ACCOUNT UNLOCK;
ALTER USER NGSTATICUSER PROFILE SDMSPROFILE;

ALTER USER NGPROJMGR ACCOUNT UNLOCK;
ALTER USER NGPROJMGR PROFILE SDMSPROFILE;

/* Unlock and set the profile for the NuGenesis ELN schema account.
/* Don't change the password for ELNPROD without also updating the ELN application server and the Document Creator Service. */
ALTER USER ELNPROD ACCOUNT UNLOCK;
ALTER USER ELNPROD PROFILE SDMSPROFILE;

/* Lock NGSDMS60 and NGSYSUSER.  These accounts are locked in the default SDMS database installation. */
ALTER USER NGSDMS60	ACCOUNT LOCK;
ALTER USER NGSYSUSER	ACCOUNT LOCK;

/* Reset the passwords for NGPROXY, NGSTATICUSER, and NGPROJMGR to their defaults. */
VAR RET number;
SET serveroutput on autoprint on;
EXECUTE ngsysuser.NGSDMS60_DEFINITIONS.sdms70proxychange(NG_USER=>'ngproxy',NG_PASS=>'global_1',ng_status=>:RET);
PROMPT 'Return status of NGPROXY'
PRINT :RET
EXECUTE ngsysuser.NGSDMS60_DEFINITIONS.sdms70appchange('NGPROJMGR','manager1','SDMS80DATA','TEMP',:RET);
PROMPT 'Return status of NGPROJMGR'
PRINT :RET
show errors;

alter USER ngstaticuser IDENTIFIED BY ngmenfogp_1;

/* Changes in Rev. 6: check the status of the case-sensitive-logon parameter.  This option, if set to TRUE,
/* is known to be incompatible with NuGenesis SDMS. */
SELECT name, value, display_value FROM v$parameter WHERE name = 'sec_case_sensitive_logon';

DECLARE
v_ParamName		v$parameter.name%TYPE;
v_ParamValue		v$parameter.value%TYPE;
v_ParamDisplayValue	v$parameter.display_value%TYPE;

BEGIN
	SELECT value INTO v_ParamValue FROM v$parameter WHERE name = 'sec_case_sensitive_logon';
	IF 	(v_ParamValue = 'TRUE') THEN
		DBMS_OUTPUT.PUT_LINE('!!!!!!!!!!!!!!!!!!!!!!!!!! WARNING !!!!!!!!!!!!!!!!!!!!!!!!!!!!');
		DBMS_OUTPUT.PUT_LINE('!!!!!!! Case-sensitive logons are enabled in this instance !!!!');
		DBMS_OUTPUT.PUT_LINE('!!!!!! Users will not be able to login to SDMS applications !!!');
		DBMS_OUTPUT.PUT_LINE('!!!!!!!!!!!!!!!!!!!!!!!!!! WARNING !!!!!!!!!!!!!!!!!!!!!!!!!!!!');
	ELSIF	(v_ParamValue = 'FALSE') THEN	DBMS_OUTPUT.PUT_LINE('Case-sensitive logons are disabled in this instance.');
	ELSE	DBMS_OUTPUT.PUT_LINE('Unknown value for sec_case_sensitive_logon='||v_ParamValue);
	END IF;
END;
/

spool off