Results for AUTHID


1 to 20 of 56 results.
Results per page:  20 | 40


User's Guide and Reference, 10g Release 1 (10.1)

8 Using PL/SQL Subprograms

Using Invoker's Rights Versus Definer's Rights (AUTHID Clause)you change it, you must recompile it in each schema. A more maintainable way is to use the AUTHID … , my_loc VARCHAR2) AUTHID CURRENT_USER AS BEGIN INSERT INTO dept VALUES (my_deptno, my_dname, my_loc); END; /

User's Guide and Reference, 10g Release 1 (10.1)

8 Using PL/SQL Subprograms

Specifying the Privileges for a Subprogram with the AUTHID ClauseTo implement invoker's 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 … CREATE TYPE statement, you can include either AUTHID CURRENT_USER or AUTHID DEFINER immediately before … or object

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00722: supertypes's AUTHID is different than subtype's AUTHID(possibly by adding a REF or by using another type). PLS-00722: supertypes's AUTHID is different than subtype's AUTHID

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00160: AUTHID must specify CURRENT_USER or DEFINERCause: An AUTHID clause was specified for a subprogram inside a package or type. These clauses are … only supported for top-level stored procedures, packages, and types. Action: Remove the clause PLS-00160: AUTHID must specify CURRENT_USER or DEFINER

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00157: AUTHID only allowed on schema-level programs: Remove the constraint. PLS-00157: AUTHID only allowed on schema-level programs

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00259: rights model (AUTHID) must be specified, BINARY_INTEGER or PLS_INTEGER PLS-00259: rights model (AUTHID) must be specified

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00714: supertypes's AUTHID is DEFINER but supertype and subtype are not in same schemait and instantiate variables of the subtype. PLS-00714: supertypes's AUTHID is DEFINER but supertype and subtype are not in same schema

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

Security Model… When creating the procedure, users can set 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

User's Guide and Reference, 10g Release 1 (10.1)

7 Performing SQL Operations with Native Dynamic SQL

Using Invoker Rights with Dynamic SQL, name IN VARCHAR2) AUTHID CURRENT_USER AS BEGIN EXECUTE IMMEDIATE 'DROP ' || kind || ' ' || name; END … ; / Let's say that this procedure is part of the HR schema. Without the AUTHID clause, the procedure … . The AUTHID clause lifts both of these restrictions. It lets the procedure run with the privileges of … . For details,

User's Guide and Reference, 10g Release 1 (10.1)

8 Using PL/SQL Subprograms

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

Packages and Types Reference, 10g Release 1 (10.1)

90 DBMS_SQL

Security ModelDBMS_SQL is compiled with AUTHID CURRENT_USER. Any DBMS_SQL subprograms called from an anonymous PL

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

8 Calling External Procedures

Locations of Call Specificationsexamples showing some of the other locations. Note: In the following examples, the AUTHID and … : Locating a Call Specification in a PL/SQL Package CREATE OR REPLACE PACKAGE Demo_pack AUTHID DEFINER AS … ; Example: Locating a Call Specification in a PL/SQL Package Body CREATE OR REPLACE PACKAGE Demo_pack AUTHID … REPLACE LIBRARY

User's Guide and Reference, 10g Release 1 (10.1)

8 Using PL/SQL Subprograms

8 Using PL/SQL SubprogramsUsing Invoker's Rights Versus Definer's Rights (AUTHID Clause) Using Recursion with PL/SQL Calling

User's Guide and Reference, 10g Release 1 (10.1)

8 Using PL/SQL Subprograms

How External References Are Resolved in Invoker's 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

Application Developer's Guide - Object-Relational Features, 10g Release 1 (10.1)

8 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 … atype AUTHID CURRENT_USER AS OBJECT( a1 NUMBER, STATIC PROCEDURE newa(p1 NUMBER, tabname VARCHAR2 … CREATE TYPE schema2.subtype2 UNDER deftype1 (...); --ERROR CREATE TYPE invtype1 AUTHID CURRENT_USER AS

Reference, 10g Release 1 (10.1)

SI_PositionalColor Object Type

SI_PositionalColor Object Typefollows: CREATE OR REPLACE TYPE SI_PositionalColor AUTHID CURRENT_USER AS OBJECT ( --attributes

Reference, 10g Release 1 (10.1)

SI_Color Object Type

SI_Color Object Typefollows: CREATE OR REPLACE TYPE SI_Color AUTHID CURRENT_USER AS OBJECT ( ------------------- -- TYPE

Reference, 10g Release 1 (10.1)

SI_AverageColor Object Type

SI_AverageColor Object TypeAverageColor object type is defined as follows: CREATE OR REPLACE TYPE SI_AverageColor AUTHID

Reference, 10g Release 1 (10.1)

SI_Texture Object Type

SI_Texture Object TypeREPLACE TYPE SI_Texture AUTHID CURRENT_USER AS OBJECT ( --attributes SI_TextureEncoding

User's Guide and Reference, 10g Release 1 (10.1)

9 Using PL/SQL Packages

What Is a PL/SQL Package?variables and do any other one-time setup steps. The AUTHID clause determines whether all the packaged … more information, see "Using Invoker's Rights Versus Definer's Rights (AUTHID Clause)". A call spec


Was this page helpful?