Skip to Main Content

SQL & PL/SQL

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 can AUTHID DEFINER package know what user called it?

Prze-moCApr 9 2020 — edited Apr 10 2020

Hello experts!

I'm stuck rewriting my package back and forth changing AUTHID from DEFINER to CURRENT_USER and back...

All because one procedure in the package must be called with DEFINER while another one must use CURRENT_USER. The rest of the package works either way.

Do I really need to create two packages? Is there any possibility to retain a single package?

Is there any way the package with AUTHID DEFINER knows what user called its procedures/functions?

Przemek,

Comments
Post Details
Added on Apr 9 2020
6 comments
5,785 views