set serveroutput on size 1000000
set feedback off
-- Workspace, user group and user export
-- Generated 2009.01.06 13:06:48 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=>982802811840052);
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 SALESTRACK...
begin
wwv_flow_fnd_user_api.create_company (
  p_id                      => 982921341840289,
  p_provisioning_company_id => 982802811840052,
  p_short_name              => 'SALESTRACK',
  p_first_schema_provisioned=> 'SALESTRACK',
  p_company_schemas         => 'OLAPTRAIN:SALESTRACK',
  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      => '982703087840052',
  p_user_name    => 'ADMIN',
  p_first_name   => '',
  p_last_name    => '',
  p_description  => '',
  p_email_address=> 'martin.gubar@oracle.com',
  p_web_password => '8DF155F03639AD1FE5951213FE239CF9',
  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=> 'SALESTRACK',
  p_account_locked=> 'N',
  p_account_expiry=> to_date('200709201440','YYYYMMDDHH24MI'),
  p_failed_access_attempts=> 0,
  p_change_password_on_first_use=> 'Y',
  p_first_password_use_occurred=> 'N',
  p_allow_access_to_schemas => '');
end;
/
begin
wwv_flow_fnd_user_api.create_fnd_user (
  p_user_id      => '999318182883572',
  p_user_name    => 'DM',
  p_first_name   => '',
  p_last_name    => '',
  p_description  => '',
  p_email_address=> 'martin.gubar@oracle.com',
  p_web_password => 'F78CF371B6F636E27632F66691C2AE66',
  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=> 'dm',
  p_account_locked=> 'N',
  p_account_expiry=> to_date('200809021327','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      => '1092624537270797',
  p_user_name    => 'OLAPTRAIN',
  p_first_name   => '',
  p_last_name    => '',
  p_description  => '',
  p_email_address=> 'olaptrain@oracle.com',
  p_web_password => '63079E96920A8B0D3B444521148887BF',
  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=> 'olaptrain',
  p_account_locked=> 'N',
  p_account_expiry=> to_date('200809050859','YYYYMMDDHH24MI'),
  p_failed_access_attempts=> 0,
  p_change_password_on_first_use=> 'N',
  p_first_password_use_occurred=> 'N',
  p_allow_access_to_schemas => '');
end;
/
commit;
set feedback on
prompt  ...done