EBS 创建用户
DECLARE
v_user_name VARCHAR2(100) := upper('&Enter_User_Name');
v_description VARCHAR2(100) := 'NEW Test User';
BEGIN
fnd_user_pkg.createuser(x_user_name => v_user_name,
x_owner => NULL,
x_unencrypted_password => '&input_password',
x_session_number => 0,
x_start_date => SYSDATE,
x_end_date => NULL,
x_last_logon_date => NULL,
x_description => v_description,
x_password_date => NULL,
x_password_accesses_left => NULL,
x_password_lifespan_accesses => NULL,
x_password_lifespan_days => NULL,
x_employee_id => NULL,
x_email_address => NULL,
x_fax => NULL,
x_customer_id => NULL,
x_supplier_id => NULL,
x_user_guid => NULL,
x_change_source => NULL);
COMMIT;
END;
本文来自博客园,作者:Iven_lin,转载请注明原文链接:https://www.cnblogs.com/ivenlin/p/18762773
浙公网安备 33010602011771号