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 USERENV


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


SQL Reference, 10g Release 1 (10.1)

USERENV

USERENVSyntax userenv::= Description of the illustration userenv.gif Purpose Note: USERENV is a legacy … function with the built-in USERENV namespace for current functionality. See SYS_CONTEXT for more … information. USERENV returns information about the current session. This information can be useful for … currently

SQL Reference, 10g Release 1 (10.1)

USERENV

Parameter Return ValueTable 7-12 Parameters of the USERENV Function Parameter Return Value CLIENT_INFO CLIENT_INFO … parameter of the current session: SELECT USERENV('LANGUAGE') "Language" FROM DUAL; Language ----------------------------------- AMERICAN_AMERICA.WE8ISO8859P1

Error Messages, 10g Release 1 (10.1)

4 ORA-01500 to ORA-02098

ORA-01725: USERENV('COMMITSCN') not allowed hereCause: Self-evident. Action: Self-evident. ORA-01725: USERENV('COMMITSCN') not allowed here

Error Messages, 10g Release 1 (10.1)

5 ORA-02140 to ORA-04099

ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.and correct the error in hash expression. ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.

Error Messages, 10g Release 1 (10.1)

4 ORA-01500 to ORA-02098

ORA-01721: USERENV(COMMITSCN) invoked more than once in a transactionobject. Action: Obtain the grant option on all underlying objects of the view. ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on Check Constraints You cannot specify a check constraint for a view. However, you can…SCOPE REF Constraints In a table with a REF column, each REF value in the column can conceivably reference a row in a different object table. The SCOPE clause restricts the scope of references to a single table, scope_table. The values in the REF column or attribute point to objects in scope_table, in which object instances of the same type as the REF column are stored. Specify the SCOPE clause to

Security Guide, 10g Release 1 (10.1)

13 Using Virtual Private Database to Implement Application Security Policies

Features of Application ContextEach Application Providing Access to Predefined Attributes through the USERENV Namespace Externalized … Access to Predefined Attributes through the USERENV Namespace Oracle database server provides a built-in … application context namespace, USERENV, which provides access to predefined attributes. These … through the USERENV

Administrator's Guide, 10g Release 1 (10.1)

8 Implementing Policy Enforcement Options and Labeling Functions

Affecting Oracle Label Security Policies with Multiple SQL Predicatesa user-specified predicate such asOR SYS_CONTEXT ('USERENV', 'SESSION_USER') = ename Correct: These … ('USERENV', 'SESSION_USER') = ename) Incorrect: The predicates would not be combined in the following way … : WHERE deptno=10 AND label=100 OR SYS_CONTEXT ('USERENV', 'SESSION_USER') = ename

Oracle® Security Overview, 10g Release 1 (10.1)

9 Oracle Security Products and Features

Database-Enforced VPD Network AccessIP address of the client connection using the USERENV naming context as follows: SYS_CONTEXT … ('userenv', 'ip_address') Further, the policy function can be defined to permit access to data only if the … application server. Specifically, the VPD policy function can use the USERENV naming context … SYS_CONTEXT('userenv',

Security Guide, 10g Release 1 (10.1)

14 Implementing Application Context and Fine-Grained Access Control

Task 1: Create a PL/SQL Package that Sets the Context for Your ApplicationEname = SYS_CONTEXT('USERENV', 'SESSION_USER'); DBMS_SESSION.SET_CONTEXT('app_context', 'empno … namespace USERENV to access primitive contexts such as userid and Globalization Support parameters. See … Also: "Providing Access to Predefined Attributes through the USERENV Namespace" for information about … the USERENV

SQL Reference, 10g Release 1 (10.1)

DROP CONTEXT

DROP CONTEXTcannot drop the built-in namespace USERENV. See Also: SYS_CONTEXT for information on the USERENV

SQL Reference, 10g Release 1 (10.1)

SYS_CONTEXT

SYS_CONTEXT-in namespace called USERENV, which describes the current session. The predefined parameters of … namespace USERENV are listed in Table 7-11, along with the lengths of their return strings. See Also … database: CONNECT OE/OE SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER') FROM DUAL; SYS_CONTEXT … ('USERENV', 'SESSION_USER')

Security Guide, 10g Release 1 (10.1)

14 Implementing Application Context and Fine-Grained Access Control

How Fine-Grained Access Control Worksfollowing predicate: Cust_no = (SELECT Custno FROM Customers WHERE Custname = SYS_CONTEXT ('userenv … WHERE Custname = SYS_CONTEXT('userenv', 'session_user')) The Oracle database server executes the … ('userenv','session_user') to look up the corresponding customer and to limit the data returned from

Security Guide, 10g Release 1 (10.1)

12 Introducing Database Security for Application Developers

Creating Secure Application Rolesthe USERENV namespace attributes ('userenv', ). The information returned by this function can … " for conceptual information about this topic Table 13-1, " Key to Predefined Attributes in USERENV

Globalization Support Guide, 10g Release 1 (10.1)

6 Supporting Multilingual Databases with Unicode

Storing Data in Multiple Languageslanguage_id = sys_context('USERENV','LANG'); Select Translated Data Using Fine-Grained Access Control … = sys_context('userenv', 'LANG') Specify this WHERE clause as a fine-grained access policy for … return 'language_id = sys_context(''userenv'', ''LANG'')'; end / DBMS_RLS.ADD_POLICY ('scott

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

3 Maintaining Data Integrity Through Constraints

Restrictions on CHECK Constraintscannot contain subqueries or sequences. The condition cannot include the SYSDATE, UID, USER, or USERENV

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

3 Maintaining Data Integrity Through Constraints

Setting Default Column ValuesSYSDATE, SYS_CONTEXT, USER, USERENV, and UID. Default values cannot include expressions that refer to a

Security Guide, 10g Release 1 (10.1)

14 Implementing Application Context and Fine-Grained Access Control

How to Use Global Application Contextcontext uses the CLIENT_IDENTIFIER USERENV namespace attribute, set with the DBMS_SESSION interface, to

Security Guide, 10g Release 1 (10.1)

15 Preserving User Identity in Multitiered Environments

Oracle Database Solutions for Preserving User IdentityUSERENV application context namespace for application users. These users are known to an application but

Security Guide, 10g Release 1 (10.1)

6 Access Controls on Tables, Views, Synonyms, or Rows

Application Context, USERENV, which provides access to predefined attributes. These attributes are session primitives … USERENV application context. Each application has its own application-specific context, which users