ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Create a Oracle Application account

Create a Oracle Application account

原创 Linux操作系统 作者:ityilong 时间:2008-01-17 17:36:02 0 删除 编辑
-- 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;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/312870/viewspace-150440/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-02

  • 博文量
    15
  • 访问量
    19680