Tuesday, December 16, 2014

Add Sysadmin Responsibility For user in Oracle Apps

BEGIN
   fnd_user_pkg.addresp (username         => UPPER ('username'),
                         resp_app         => 'SYSADMIN',
                         resp_key         => 'SYSTEM_ADMINISTRATOR',
                         security_group   => 'STANDARD',
                         description      => 'DESCRIPTION',
                         start_date       => SYSDATE,
                         end_date         => NULL);
   COMMIT;
   DBMS_OUTPUT.put_line ('Responsibility Added Successfully');
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line(   'Responsibility is not added due to'
                           || SQLCODE
                           || SUBSTR (SQLERRM, 1, 100));
      ROLLBACK;
END;
/

1 comment:

  1. This is how my partner Wesley Virgin's report begins with this shocking and controversial video.

    As a matter of fact, Wesley was in the army-and soon after leaving-he unveiled hidden, "self mind control" tactics that the CIA and others used to get whatever they want.

    THESE are the exact same SECRETS lots of celebrities (notably those who "became famous out of nowhere") and the greatest business people used to become rich and successful.

    You probably know how you use only 10% of your brain.

    Mostly, that's because the majority of your BRAINPOWER is UNCONSCIOUS.

    Maybe that thought has even occurred INSIDE OF YOUR very own head... as it did in my good friend Wesley Virgin's head around seven years ago, while riding an unlicensed, beat-up trash bucket of a car with a suspended license and with $3.20 on his debit card.

    "I'm so fed up with going through life paycheck to paycheck! When will I become successful?"

    You've been a part of those those thoughts, isn't it so?

    Your very own success story is going to happen. You just need to take a leap of faith in YOURSELF.

    Watch Wesley Virgin's Video Now!

    ReplyDelete