set serveroutput on size 1000000
set feedback off
-- Workspace, user group and user export
-- Generated 2012.08.15 17:26:47 by ADMIN
-- This script can be run in sqlplus as the owner of the Oracle Apex owner.
begin
    wwv_flow_api.set_security_group_id(p_security_group_id=>11019802792885519);
end;
/
----------------
-- W O R K S P A C E
-- Creating a workspace will not create database schemas or objects.
-- This API will cause only meta data inserts.
prompt  Creating workspace MIP_DEV...
begin
wwv_flow_fnd_user_api.create_company (
  p_id                      => 11019900530885559,
  p_provisioning_company_id => 11019802792885519,
  p_short_name              => 'MIP_DEV',
  p_first_schema_provisioned=> 'MIP_DEV',
  p_company_schemas         => 'MIP_BULK:MIP_DEV:MIP_DEV_B:MIP_DEV_C:MIP_DEV_E:MIP_TRAIN:NEWMIP:TAQA_DEV',
  p_expire_fnd_user_accounts=> '',
  p_account_lifetime_days=> '',
  p_fnd_user_max_login_failures=> '');
end;
/
----------------
-- G R O U P S
--
prompt  Creating Groups...
----------------
-- U S E R S
-- User repository for use with apex cookie based authenticaion.
--
prompt  Creating Users...
begin
wwv_flow_fnd_user_api.create_fnd_user (
  p_user_id      => '11019707221885519',
  p_user_name    => 'ADMIN',
  p_first_name   => '',
  p_last_name    => '',
  p_description  => '',
  p_email_address=> 'andrew.hardy@advanticagroup.com',
  p_web_password => 'C2856D932B8746EF1CDC7FF52FC9B640',
  p_web_password_format => 'HEX_ENCODED_DIGEST_V2',
  p_group_ids    => '',
  p_developer_privs=> 'ADMIN:CREATE:DATA_LOADER:EDIT:HELP:MONITOR:SQL',
  p_default_schema=> 'MIP_DEV',
  p_account_locked=> 'N',
  p_account_expiry=> to_date('200808141645','YYYYMMDDHH24MI'),
  p_failed_access_attempts=> 2,
  p_change_password_on_first_use=> 'N',
  p_first_password_use_occurred=> 'Y',
  p_allow_access_to_schemas => '');
end;
/
begin
wwv_flow_fnd_user_api.create_fnd_user (
  p_user_id      => '11034806496913942',
  p_user_name    => 'HARDYA',
  p_first_name   => 'Andy',
  p_last_name    => 'Hardy',
  p_description  => 'Technical Lead',
  p_email_address=> 'andrew.hardy@advanticagroup.com',
  p_web_password => '5DED88A6DEF63EBF3EE81C9CA1CB86AA',
  p_web_password_format => 'HEX_ENCODED_DIGEST_V2',
  p_group_ids    => '',
  p_developer_privs=> 'ADMIN:CREATE:DATA_LOADER:EDIT:HELP:MONITOR:SQL',
  p_default_schema=> 'MIP_DEV',
  p_account_locked=> 'N',
  p_account_expiry=> to_date('201206120957','YYYYMMDDHH24MI'),
  p_failed_access_attempts=> 0,
  p_change_password_on_first_use=> 'N',
  p_first_password_use_occurred=> 'Y',
  p_allow_access_to_schemas => '');
end;
/
begin
wwv_flow_fnd_user_api.create_fnd_user (
  p_user_id      => '11037827105957740',
  p_user_name    => 'MULLENM',
  p_first_name   => 'Matt',
  p_last_name    => 'Mullen',
  p_description  => 'Developer',
  p_email_address=> 'matthew.mullen@advanticagroup.com',
  p_web_password => 'A6E5E4057D6094FA63FFD8B1DE2F7B86',
  p_web_password_format => 'HEX_ENCODED_DIGEST_V2',
  p_group_ids    => '',
  p_developer_privs=> 'ADMIN:CREATE:DATA_LOADER:EDIT:HELP:MONITOR:SQL',
  p_default_schema=> 'MIP_DEV',
  p_account_locked=> 'N',
  p_account_expiry=> to_date('201008251627','YYYYMMDDHH24MI'),
  p_failed_access_attempts=> 0,
  p_change_password_on_first_use=> 'N',
  p_first_password_use_occurred=> 'Y',
  p_allow_access_to_schemas => '');
end;
/
begin
wwv_flow_fnd_user_api.create_fnd_user (
  p_user_id      => '11037326282948053',
  p_user_name    => 'PRIESTJ',
  p_first_name   => 'Jamie',
  p_last_name    => 'Priest',
  p_description  => 'Developer',
  p_email_address=> 'Jamie.Priest@advanticagroup.com ',
  p_web_password => 'A616A4299139717DEA222B881EE7D4F4',
  p_web_password_format => 'HEX_ENCODED_DIGEST_V2',
  p_group_ids    => '',
  p_developer_privs=> 'ADMIN:CREATE:DATA_LOADER:EDIT:HELP:MONITOR:SQL',
  p_default_schema=> 'MIP_DEV',
  p_account_locked=> 'N',
  p_account_expiry=> to_date('201110201158','YYYYMMDDHH24MI'),
  p_failed_access_attempts=> 0,
  p_change_password_on_first_use=> 'N',
  p_first_password_use_occurred=> 'Y',
  p_allow_access_to_schemas => '');
end;
/
commit;
set feedback on
prompt  ...done