Adding Responsibility to a user from backend

Begin
fnd_user_pkg.addresp (‘YOUR_USER_NAME’,’SYSADMIN’,’SYSTEM_ADMINISTRATOR’,’STANDARD’,’add responsibility to user using pl/sql’,sysdate-1,sysdate + 100);
commit;
dbms_output.put_line(‘responsibility added successfully to the user ‘);
exception
when others then
dbms_output.put_line(‘ responsibility adding failed due to’ || sqlcode || substr(sqlerrm, 1, 100));
rollback;
end;

–You can view the changes immediately.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s