Skip to Main Content

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!

Run pl/sql or stored procedure as different user

Mcardozo-OracleOct 7 2014 — edited Oct 21 2014

I have a stored procedure that lives in the database.  This procedure is owned by a schema that is not related to any workspace.  I have created a workspace and schema (schema1).  schema1 has been granted access to run the procedure, and can do so by logging in to the db with sql developer.  Unfortunately when trying to run the procedure from within apex, it's connecting as apex_public_user, which does not have sufficient privileges.

Is there any way within APEX to run this procedure as schema1 rather than apex_public_user?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2014
Added on Oct 7 2014
23 comments
17,513 views