有資料庫apps許可權，但是沒有oracle EBS 帳戶

有資料庫apps許可權，但是沒有oracle EBS 帳戶， 可以用以下方法建立一個使用者使用：

1.前提，擁有其它EBS 的許可權，然後

select * from fnd_user where user_name='AARON' --login name

選出來一行， copy 整個行

copy 內容：

1 21944 AARON 2006-8-29 17:04:06 21944 2006-8-10 9:25:58 3179 9561331 ZG3C8000A17CFB4DB9F702345FEA12FEE240869C1DBAA445243CCD574ABFE1C2CBA250D85BB40E91F5C4FA57FBAF10CEC59F ZG21C226D20200C5A3763B9BE97272F296BBA3E852F70FE0E5B040FA02F2CFC0E5E67942364F5774BC689F8F1E81ECAC845D 242 2006-8-10 2006-9-8 16:56:04 2006-8-10 9:26:31 29502 154958

2.用pl/sql developer 開啟另一個session , 執行

select * from fnd_user where user_name='AARON' for update

加鎖，然後paste

到這裡使用者已經建立

3. 回到擁有許可權的APPS串連

select * from fnd_user_resp_groups where user_id=21944

--上步選出來的user id .

copy 內容：

21945 20419 0 0 2006-8-14 Application Object Library Application Developer 21944 2006-8-14 9:34:09 21944 2006-8-14 9:34:09 9518984
21945 20420 1 0 2006-8-10 Application Object Library System Adminstrator 3179 2006-8-10 9:26:00 3179 2006-8-10 9:26:00 9507604
21945 21345 190 0 2006-8-10 Implementation Wizard's Responsibility to Access All Manufacturing Setup Forms 21944 2006-8-10 17:49:17 21944 2006-8-10 17:49:17 9508364
21945 50215 201 0 2006-8-17 21944 2006-8-17 13:43:48 21944 2006-8-17 13:43:48 9527828
21945 50217 401 0 2006-8-10 21944 2006-8-10 9:33:15 21944 2006-8-10 9:33:15 9507609
21945 50218 660 0 2006-8-14 21944 2006-8-14 9:44:19 21944 2006-8-14 9:44:19 9518984
21945 50221 190 0 2006-8-10 21944 2006-8-10 9:33:15 21944 2006-8-10 9:33:15 9507609
21945 50871 702 0 2006-8-16 HUTS BOM STANDARD USER 21944 2006-8-16 9:48:59 21944 2006-8-16 9:48:59 9524472
21945 50900 401 0 2006-8-25 HUTS ORG Items Maintain ALL 21944 2006-8-25 16:11:49 21944 2006-8-25 16:11:49 9550296
21945 50920 702 0 2006-8-25 UTCN BOM Standard User 21944 2006-8-25 16:11:48 21944 2006-8-25 16:11:48 9550296
21945 52027 401 0 2006-8-10 Interface Manager Administrator 21944 2006-8-10 9:33:15 21944 2006-8-10 9:33:15 9507609
21945 54083 20003 0 2006-8-15 21944 2006-8-15 11:29:02 21944 2006-8-15 11:29:02 9521887

4. 重複第二步，執行：

select * from fnd_user_resp_groups where user_id=21945 for update

paste 第三步的結果

有的時候需要改一下user_id(系統裡21944的user_id 已經存在),2, 4 步user_id都需要改一下