AUTHID CURRENT_USER and AUTHID DEFINER

Oracle Apps developers get confused with these 2 terms when to be used AUTHID CURRENT_USER and when to be used AUTHID DEFINER.

Ill  brief you about these 2 in the below paragraph.

AUTHID CURRENT_USER

This clause is used when you want to execute a piece of code with execute privilege of current user but not with the privilege of the user who defined the pl/sql code.

This is termed as “invoker rights”, the opposite of “definer rights”.

AUTHID DEFINER

AUTHID DEFINER is exactly opposite to AUTHID CURRENT_USER where a user can execute the pl/sql code with definer privileges. Using this clause is as same as granting public access to the pl/sql