Howto Create custom database user to call fnd_user_pkg procedures

Dear all,

We need to update Oracle EBS user passwords from our AD. Our plan is to use the following procedure call to perform that task.

declare

l_ok BOOLEAN;

begin

l_ok := apps.fnd_user_pkg.changepassword('JOHN','secret01');

end;

The problem is that we need a new db user with limited rights to preform that task and thus not need to use the apps account. We created a new db user with execute rights on this procedure. Unfortunately this does not work, since the call errors out because of lack of rights on packages used by fnd_user_pkg.