The following script helps with the creation of an oracle e-business user / fnd user from the command line. It also has code snippets that will let you add a responsibility and change password if required.
DECLARE
l_user_id NUMBER;
result1 BOOLEAN;
BEGIN
--CODE TO CREATE A NEW USER
l_user_id :=
fnd_user_pkg.createuserid (x_user_name => 'USER1',
x_owner => '',
x_unencrypted_password => 'welcome1',
x_session_number => 0,
x_start_date => SYSDATE
);
--CODE TO CHANGE PASSWORD OF A USER
result1:= fnd_user_pkg.changepassword('USER1','welcome123');
--CODE TO ADD A RESPONSIBILITY
fnd_user_pkg.addresp (username => 'USER1',
resp_app => 'SYSADMIN',
resp_key => 'SYSTEM_ADMINISTRATOR',
security_group => 'STANDARD',
description => '',
start_date => SYSDATE,
end_date => NULL
);
DBMS_OUTPUT.put_line (l_user_id);
END;
DECLARE
l_user_id NUMBER;
result1 BOOLEAN;
BEGIN
--CODE TO CREATE A NEW USER
l_user_id :=
fnd_user_pkg.createuserid (x_user_name => 'USER1',
x_owner => '',
x_unencrypted_password => 'welcome1',
x_session_number => 0,
x_start_date => SYSDATE
);
--CODE TO CHANGE PASSWORD OF A USER
result1:= fnd_user_pkg.changepassword('USER1','welcome123');
--CODE TO ADD A RESPONSIBILITY
fnd_user_pkg.addresp (username => 'USER1',
resp_app => 'SYSADMIN',
resp_key => 'SYSTEM_ADMINISTRATOR',
security_group => 'STANDARD',
description => '',
start_date => SYSDATE,
end_date => NULL
);
DBMS_OUTPUT.put_line (l_user_id);
END;
No comments:
Post a comment