Oracle EBS – Application User Maintenance SQL Scripts

Here are the SQL Scripts to create application user, reset application user’s password and adding responsibility thru SQL Plus / Toad / SQL Developer. Connect as APPS to execute the scripts. Creating application user — creating application userDECLAREl_user_name VARCHAR2(100) := UPPER(‘VMITTAKANTI‘); — Usernamel_password VARCHAR2(30) := ‘Welcome1‘; — Passwordl_session_id INTEGER := USERENV(‘sessionid’);BEGINfnd_user_pkg.createuser (x_user_name => l_user_name,x_owner => … Read more


Go to Source of this post
Author Of this post: Venkanna Mittakanti
Title Of post: Oracle EBS – Application User Maintenance SQL Scripts
Author Link: {authorlink}