存储过程调用对象权限语句 AUTHID

存储过程调用对象权限语句

 

文本描述：AUTHID { CURRENT_USER | DEFINER }

调用权限允许你指定存储过程执行的权限是在所有者自己的用户还是在CURRENT_USER中执行。

AUTHID CURRENT_USER
Specify CURRENT_USER to indicate that the procedure executes with the privileges of CURRENT_USER. This clause creates an invoker-rights procedure.
This clause also specifies that external names in queries, DML operations, and dynamic SQL statements resolve in the schema of CURRENT_USER. External names in all other statements resolve in the schema in which the procedure resides.
AUTHID DEFINER
Specify DEFINER to indicate that the procedure executes with the privileges of the owner of the schema in which the procedure resides, and that external names resolve in the schema where the procedure resides. This is the default and creates a definer-rights procedure.