创建用户，添加职责，修改用户代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】创建用户，添加职责，修改用户

作者:Dezai.CN / 发布于2013/1/7/ 1369

DECLARE

a BOOLEAN;

BEGIN
-------------------------------------------------------------
--Change password
-------------------------------------------------------------
-------------------------------------------------------------
--Create User
-------------------------------------------------------------

fnd_user_pkg.CreateUser('SIMON',
'SEED',
'PW$234567'
);
-------------------------------------------------------------
--Add Resp
--select * from fnd_responsibility fr where fr.responsibility_id =
--select * from fnd_responsibility_tl frt where upper(frt.responsibility_name) like '%%'
--select * from fnd_application fa where fa.application_id =
--select * from fnd_security_groups fs
-------------------------------------------------------------
fnd_user_pkg.AddResp ('SIMON',
'SYSADMIN',
'SYSTEM_ADMINISTRATOR',
'STANDARD',
'Test API',
sysdate,
null
);
Commit;
End;

试试其它关键字

　创建用户　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)