In Oracle, the AUTHID
clause is a powerful option to manage DB security and access control. It defines who is considered a current user for execution purposes within stored procedures and functions. This article explores the basics of AUTHID
, different settings, and how to use it effectively.
About AUTHID
The AUTHID
clause specifies whether the current user for authorization checks is the owner of the procedure or function (AUTHID DEFINER
) or the user who invokes it (AUTHID CURRENT_USER
).
This article has been indexed from DZone Security Zone