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: