You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for AUTHID


1 to 20 of 47 results. Previous page Prev  Next next page
Results per page:   20  | 40


User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Subprograms

Specifying the Privileges for a Subprogram with the AUTHID ClauseTo implement invoker rights, use the AUTHID clause, which specifies whether a subprogram executes … the current user. The AUTHID clause is allowed only in the header of a standalone subprogram, a … ] FUNCTION [schema_name.]function_name [(parameter_list)] RETURN datatype [AUTHID {CURRENT_USER | DEFINER … [(parameter_list)] [AUTHID

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00722 supertypes's AUTHID is different than subtype's AUTHIDCause: The subtype's AUTHID must be the same as the supertype's AUTHID. Action: Create the subtype … with the AUTHID of its supertype or do not specify an AUTHID for the subtype.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00157 AUTHID only allowed on schema-level programsCause: An AUTHID clause was specified for a subprogram inside a package or type. These clauses are

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00259 rights model (AUTHID) must be specifiedHAS CALL-Specifications. Action: Add the AUTHID clause indicating the rights model.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00160 AUTHID must specify CURRENT_USER or DEFINERCause: The only two allowed options for AUTHID are CURRENT_USER and DEFINER. Action: Fix the AUTHID clause to specify CURRENT_USER or DEFINER.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00714 supertypes's AUTHID is DEFINER but supertype and subtype are not in same schemaCause: The supertype's AUTHID is DEFINER, but the supertype and subtype are defined in different

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOB, 1 of 2

Security for DBMS_LOBset the AUTHID to indicate whether they want definer's rights or invoker's rights. For example: CREATE … PROCEDURE proc1 authid definer... or CREATE PROCEDURE proc1 authid current_user.... See Also: For … more information on AUTHID and privileges, see PL/SQL User's Guide and Reference You can provide

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Subprograms

Using Object Types with Invoker-Rights SubprogramsTo define object types for use in any schema, specify the AUTHID CURRENT_USER clause. (For more … : CREATE TYPE Num AUTHID CURRENT_USER AS OBJECT ( x NUMBER, STATIC PROCEDURE new_num ( n NUMBER … AUTHID clause, it inherits the AUTHID of its supertype. If a subtype does specify an AUTHID clause

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Calling External Procedures

Locations of Call Specificationssome of the other locations. Note: In the following examples, the AUTHID and SQL_NAME_RESOLVE clauses … a PL/SQL Package CREATE OR REPLACE PACKAGE Demo_pack AUTHID DEFINER AS PROCEDURE … Specification in a PL/SQL Package Body CREATE OR REPLACE PACKAGE Demo_pack AUTHID CURRENT_USER AS PROCEDURE … /lib.so'; CREATE OR REPLACE TYPE

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Subprograms

How External References Are Resolved in Invoker-Rights SubprogramsIf you specify AUTHID CURRENT_USER, the privileges of the current user are checked at run time, and … . CREATE PROCEDURE reconcile (acc_id IN INTEGER) AUTHID CURRENT_USER AS bal NUMBER; BEGIN bal … (4), ename VARCHAR2(15)); / CREATE PROCEDURE evaluate (my_empno NUMBER) AUTHID CURRENT_USER AS

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SQL, 1 of 2

Securityprivileges of the invoker of the module. When a module has AUTHID set to current_user, the … PROCEDURE income(amount number) AUTHID current_user IS c number; n number; BEGIN c:= dbms_sql.open_cursor

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Object Types

Defining Object Typesfollowing syntax: CREATE [OR REPLACE] TYPE type_name [AUTHID {CURRENT_USER | DEFINER}] { {IS | AS … } {subprogram_body | call_spec};} [{MEMBER | STATIC} {subprogram_body | call_spec};]... END;] The AUTHID

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Native Dynamic SQL

Using Invoker Rights… However, the AUTHID clause enables a stored procedure to execute with the privileges of its invoker … VARCHAR2, name IN VARCHAR2) AUTHID CURRENT_USER AS BEGIN EXECUTE IMMEDIATE 'DROP ' || kind

Application Developer's Guide - Object-Relational Features, 9i Release 2 (9.2.0.2)

Design Considerations for Oracle Objects

Writing Reusable Code using Invoker Rightsinvoker-rights, through the AUTHID CURRENT_USER option of CREATE OR REPLACE TYPE. In general, use … /TIGER. DROP TABLE atab. CREATE OR REPLACE TYPE atype AUTHID CURRENT_USER AS OBJECT(a1 NUMBER, STATIC … (...); -- ERROR CREATE TYPE invtype1 AUTHID CURRENT_USER AS OBJECT (...); -- Invoker rights type CREATE TYPE schema2.subtype2 UNDER

interMedia User's Guide and Reference, 9i Release 2 (9.2.0.2)

ORDDoc Reference Information

7.4.1 ORDPLUGINS.ORDX_DEFAULT_DOC PackageORDX_DEFAULT_DOC authid current_user AS PROCEDURE setProperties(ctx IN OUT RAW, obj IN OUT NOCOPY

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Subprograms

Overriding Default Name Resolution in Invoker-Rights SubprogramsPROCEDURE calc_bonus (emp_id INTEGER) AUTHID CURRENT_USER AS mid_sal REAL; BEGIN SELECT median(sal) INTO

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: ALTER CLUSTER to ALTER SEQUENCE, 10 of 21

Semanticsthe member functions and procedures of the type. AUTHID CURRENT_USER Specify CURRENT_USER if you want … all other statements resolve in the schema in which the methods reside. AUTHID DEFINER Specify DEFINER

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Subprograms

Invoker Rights Versus Definer Rightshampers maintenance. A better way is to use the AUTHID clause, which enables stored procedures and … , my_dname VARCHAR2, my_loc VARCHAR2) AUTHID CURRENT_USER AS BEGIN INSERT INTO dept VALUES (my_deptno, my_dname, my_loc); END;

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE LIBRARY to CREATE SPFILE, 7 of 16

Semanticsin the package. AUTHID CURRENT_USER Specify CURRENT_USER to indicate that the package executes with … package resides. AUTHID DEFINER Specify DEFINER to indicate that the package executes with the privileges

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Packages

What Is a PL/SQL Package?package_name [AUTHID {CURRENT_USER | DEFINER}] {IS | AS} [PRAGMA SERIALLY_REUSABLE … initialize package variables. The AUTHID clause determines whether all the packaged subprograms execute