Create a Oracle Application account

上一篇 / 下一篇  2008-01-17 17:36:02 / 个人分类:ERP

-- Create a Oracle Application account with the system administrator 
-- and application developer responsibilities. Please change "UserName" 
-- to the preferred username and please change "Your complete name" to 
-- your complete first and last name.
BEGIN
  fnd_user_pkg.CreateUser(x_user_name            => 'UserName'
                         ,x_owner                => 'CUST'
                         ,x_unencrypted_password => 'welcome'
                         ,x_description => 'Your complete name'
                          );

  fnd_user_pkg.AddResp(username       => 'UserName'
                      ,resp_app       => 'FND'
                      ,resp_key       => 'APPLICATION_DEVELOPER'
                      ,security_group => 'STANDARD'
                      ,description    => 'Applicatie Developer'
                      ,start_date     => SYSDATE
                      ,end_date       => NULL
                       );

  fnd_user_pkg.AddResp(username       => 'UserName'
                      ,resp_app       => 'SYSADMIN'
                      ,resp_key       => 'SYSTEM_ADMINISTRATOR'
                      ,security_group => 'STANDARD'
                      ,description    => 'System admin'
                      ,start_date     => SYSDATE
                      ,end_date       => NULL
                       );
END;

TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-01-27  
  12345
6789101112
13141516171819
20212223242526
2728293031  

我的存档

数据统计

  • 访问量: 138
  • 日志数: 13
  • 图片数: 1
  • 文件数: 1
  • 书签数: 2
  • 建立时间: 2008-01-02
  • 更新时间: 2008-01-23

RSS订阅

Open Toolbar