APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change the oracle apex end user account from apex app

JayRAug 29 2016 — edited Aug 31 2016

Hi,

Greetings.

My Environment : Oracle Application Express 5.0.3.00.03 , Oracle DB 11g Standard Edition

I have the grants on the schema and i am able to utilize apex_util api to CHANGE_CURRENT_USER_PW and APEX_UTIL.EDIT_USER etc.

I have apex app based on custom auth on table data. This all are end user in apex work space. My goal is that when i am changing password to db same time would like to sync with apex workspace users too. But it fails with errors: ORA-20987: APEX - User requires ADMIN privilege to perform this operation. - Contact your application administrator for EDIT_USER and

ORA-20987: APEX - Internal Error - Contact your application administrator - for CHANGE_CURRENT_USER_PW .

Is there any workaround for it?

Please let me know.

Thank You..

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2016

Added on Aug 29 2016

#apex-discussions

4 comments

1,124 views