blog-2-create-user-and-add-responsibility-from-backend
Query:
declare
v_user_name varchar2(30) :=’AJ_TEST’; — User Name
v_password varchar2(30) :=’johnytips’; — Password
— List of responsibilities to be added automatically
cursor cur_get_responsibilities
is
select resp.responsibility_key
,resp.responsibility_name
,app.application_short_name
from fnd_responsibility_vl resp
,fnd_application app
where resp.application_id = app.application_id
and resp.responsibility_name in ( ‘System Administrator’
,’Application Developer’
,’Functional Administrator’) ;
begin
fnd_user_pkg.createuser (
x_user_name => upper(v_user_name)
,x_owner => null
,x_unencrypted_password => v_password
,x_session_number => userenv(‘sessionid’)
,x_start_date => sysdate
,x_end_date => null );
dbms_output.put_line (‘User ‘||v_user_name||’ created !!!!!’);
for c_get_resp in cur_get_responsibilities
loop
fnd_user_pkg.addresp (
username => v_user_name
,resp_app => c_get_resp.application_short_name
,resp_key => c_get_resp.responsibility_key
,security_group => ‘STANDARD’
,description => null
,start_date => sysdate
,end_date => null);
dbms_output.put_line(‘Responsibility ‘||c_get_resp.responsibility_name||’ added !!!!!!’);
end loop;
commit;
exception
when others then
dbms_output.put_line (‘Exception : ‘||SUBSTR(SQLERRM, 1, 500));
rollback;
end;