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!

PL/SQL procedure execution rights

LauryJan 27 2016 — edited Feb 8 2016

Hi,

1)

Can someone explain me what is the BEQUEATH_CURRENT_USER view and how is it related with a PL/SQL function and AUTHID and CURRENT_USER?

I would think that the current schema, user, and enabled roles are inherited from the querying user's envoronment. But what if the current user calls a procedure from another user?

2)

For what is meant the INHERIT PRIVILEGE?

3)

What are invokers rights procedure?

4) A PL/SQL unit has by default AUTHID=DEFINER, but what means DEFINER?

Thanks and Regards.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2016
Added on Jan 27 2016
12 comments
2,691 views