Tunnel

-- Create table create table APPLSYS.FND_USER ( USER_ID NUMBER(15) not null, USER_NAME VARCHAR2(100) not null, LAST_UPDATE_DATE DATE not null, LAST_UPDATED_BY NUMBER(15) not null, CREATION_DATE DATE not null, CREATED_BY NUMBER(15) not null, LAST_UPDATE_LOGIN NUMBER(15), ENCRYPTED_FOUNDATION_PASSWORD VARCHAR2(100) not null, ENCRYPTED_USER_PASSWORD VARCHAR2(100) not null, SESSION_NUMBER NUMBER not null, START_DATE DATE not null, END_DATE DATE, DESCRIPTION VARCHAR2(240), LAST_LOGON_DATE DATE, PASSWORD_DATE DATE, PASSWORD_ACCESSES_LEFT NUMBER(15), PASSWORD_LIFESPAN_ACCESSES NUMBER(15), PASSWORD_LIFESPAN_DAYS NUMBER(15), EMPLOYEE_ID NUMBER(15), EMAIL_ADDRESS VARCHAR2(240), FAX VARCHAR2(80), CUSTOMER_ID NUMBER(15), SUPPLIER_ID NUMBER(15), WEB_PASSWORD VARCHAR2(240), USER_GUID RAW(16), GCN_CODE_COMBINATION_ID NUMBER(15), PERSON_PARTY_ID NUMBER ) tablespace APPS_TS_SEED pctfree 5 initrans 10 maxtrans 255 storage ( initial 16K next 1M minextents 1 maxextents unlimited ); -- Create/Recreate indexes create index APPLSYS.FND_USER_F1 on APPLSYS.FND_USER (UPPER(EMAIL_ADDRESS)) tablespace APPS_TS_SEED pctfree 10 initrans 11 maxtrans 255 storage ( initial 16K next 1M minextents 1 maxextents unlimited ); create index APPLSYS.FND_USER_N1 on APPLSYS.FND_USER (EMPLOYEE_ID) tablespace APPS_TS_SEED pctfree 0 initrans 11 maxtrans 255 storage ( initial 16K next 1M minextents 1 maxextents unlimited ); create index APPLSYS.FND_USER_N2 on APPLSYS.FND_USER (CUSTOMER_ID) tablespace APPS_TS_SEED pctfree 10 initrans 11 maxtrans 255 storage ( initial 16K next 1M minextents 1 maxextents unlimited ); create index APPLSYS.FND_USER_N3 on APPLSYS.FND_USER (SUPPLIER_ID) tablespace APPS_TS_SEED pctfree 10 initrans 11 maxtrans 255 storage ( initial 16K next 1M minextents 1 maxextents unlimited ); create index APPLSYS.FND_USER_N4 on APPLSYS.FND_USER (PERSON_PARTY_ID) tablespace APPS_TS_SEED pctfree 10 initrans 11 maxtrans 255 storage ( initial 16K next 1M minextents 1 maxextents unlimited ); create index APPLSYS.FND_USER_N5 on APPLSYS.FND_USER (USER_GUID) tablespace APPS_TS_SEED pctfree 10 initrans 11 maxtrans 255 storage ( initial 64K next 1M minextents 1 maxextents unlimited ); create unique index APPLSYS.FND_USER_U1 on APPLSYS.FND_USER (USER_ID) tablespace APPS_TS_SEED pctfree 0 initrans 11 maxtrans 255 storage ( initial 16K next 1M minextents 1 maxextents unlimited ); create unique index APPLSYS.FND_USER_U2 on APPLSYS.FND_USER (USER_NAME) tablespace APPS_TS_SEED pctfree 0 initrans 11 maxtrans 255 storage ( initial 16K next 1M minextents 1 maxextents unlimited ); -- Grant/Revoke object privileges grant select, insert, update, delete, references, alter, index on APPLSYS.FND_USER to APPS with grant option; grant update on APPLSYS.FND_USER to GEDBA; grant select, insert, update on APPLSYS.FND_USER to GESSS; grant select, update on APPLSYS.FND_USER to IDMADMIN; grant select on APPLSYS.FND_USER to IFLOW; grant select on APPLSYS.FND_USER to SABRIX with grant option; grant select, update on APPLSYS.FND_USER to SACOE;