Skip to content

Instantly share code, notes, and snippets.

@mortenbra
Last active November 9, 2015 08:06
Show Gist options
  • Save mortenbra/0fbc35a55274648323ed to your computer and use it in GitHub Desktop.
Save mortenbra/0fbc35a55274648323ed to your computer and use it in GitHub Desktop.
Apex post install cleanup
-- run as SYS
-- set up service profile to avoid expiring passwords
create profile web_service_profile
limit password_life_time unlimited;
alter user apex_public_user profile web_service_profile;
alter user apex_listener profile web_service_profile;
alter user apex_rest_public_user profile web_service_profile;
-- unlock the apex public user and set a password
alter user apex_public_user account unlock;
alter user apex_public_user identified by pick_a_password;
-- remove previous versions of Apex, if desired
-- drop user apex_040000 cascade;
-- drop user apex_040100 cascade;
-- drop user apex_040200 cascade;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment