How to Know if a Stored Procedure is Defined as AUTHID CURRENT_USER ?
Last updated on NOVEMBER 22, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 188.8.131.52 to 10.2.0.4 - Release: 8.1.7 to 10.2
Checked for relevance on 17-Sep-2010
However, USER_OBJECTS or ALL_OBJECTS do not hold information on AUTHID. How to know if AUTHID is DEFINER or CURRENT_USER?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms