AUTHID property of a stored PL/SQL subprogram. The
AUTHID property affects the name resolution and privilege checking of SQL statements that the unit issues at run time.
When it appears in the package declaration, it specifies the
AUTHID property of functions and procedures in the package, and of the explicit cursors declared in the package specification.
When it appears in a standalone function declaration, it specifies the
AUTHID property of the function.
When it appears in a standalone procedure declaration, it specifies the
AUTHID property of the procedure.
The invoker_rights_clause can appear only once in a subprogram declaration.
When it appears in an ADT, it specifies the
AUTHID property of the member functions and procedures of the ADT.
Restrictions on invoker_rights_clause
The following restrictions apply for types:
This clause is valid only for ADTs, not for a nested table or
You can specify this clause for clarity if you are creating a subtype. However, a subtype inherits the
AUTHIDproperty of its supertype, so you cannot specify a different value than was specified for the supertype.
If the supertype was created with
DEFINER, then you must create the subtype in the same schema as the supertype.
- You cannot specify the
AUTHIDproperty of SQL macros. They behave like IR units.
In this book:
"Invoker's Rights and Definer's Rights (AUTHID Property)"for information about the