存储过程调用对象权限语句
文本描述:AUTHID { CURRENT_USER | DEFINER }
调用权限允许你指定存储过程执行的权限是在所有者自己的用户还是在CURRENT_USER中执行。
AUTHID CURRENT_USER
Specify
CURRENT_USER
to indicate that the procedure executes with the privileges ofCURRENT_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.