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 SYS_CONTEXT


1 to 20 of 31 results. Previous page Prev  Next next page


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 122 of 177

SYS_CONTEXTSyntax sys_context::= Text description of sys_context Purpose SYS_CONTEXT returns the value of … . Restriction on SYS_CONTEXT You cannot specify this function in a parallel query. See Also: Oracle9i … database: CONNECT OE/OE SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER') FROM DUAL; SYS_CONTEXT

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

SYS_CONTEXTSYS_DBURIGEN

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 9 of 26

SemanticsUSERENV. See Also: SYS_CONTEXT for information on the USERENV namespace

Label Security Administrator's Guide, 9i Release 2 (9.2.0.2)

Advanced Topics in Oracle Label Security

OCI Interface for Setting Session LabelsWhen using OCI to connect, the policy's SYS_CONTEXT variables can be used to initialize the session … "externally initialized" SYS_CONTEXT variables. These are available in Release 8.1.7 only when Oracle Label … Security is installed. Each policy has a SYS_CONTEXT named SA$ policy_name _X. There are two

Label Security Administrator's Guide, 9i Release 2 (9.2.0.2)

Implementing Policy Options and Labeling Functions

Effect of Multiple SQL Predicates Under Oracle Label Securitya user-specified predicate such asOR SYS_CONTEXT ('USERENV', 'SESSION_USER') = ename Correct … : These predicates would be ANDed together as follows: WHERE deptno=10 AND (label=100 OR SYS_CONTEXT … : WHERE deptno=10 AND label=100 OR SYS_CONTEXT ('USERENV', 'SESSION_USER') = ename Copyright © 2000

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

Implementing Application Security Policies

How to Use Application Contextan example for creating the PL/SQL package, followed by a discussion of SYS_CONTEXT syntax and … , MANAGER ) should be set before the user accesses any data. SYS_CONTEXT Example The following … Emp_id NUMBER; BEGIN SELECT Empno INTO Emp_id FROM Emp_tab WHERE Ename = SYS_CONTEXT('USERENV … Supplied PL/SQL Packages and Types Reference

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

Implementing Application Security Policies

How Fine-Grained Access Control WorksCustno FROM Customers WHERE Custname = SYS_CONTEXT ('userenv','session_user')) A user enters the … WHERE Custno = ( SELECT Custno FROM Customers WHERE Custname = SYS_CONTEXT('userenv', 'session_user … employs the username returned by SYS_CONTEXT ('userenv','session_user')  to look up the corresponding

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

Maintaining Data Integrity Through Constraints

Setting Default Column Values, SYS_CONTEXT, USER, USERENV, and UID. Default values cannot include expressions that refer to a sequence … SQL function. For example, a call to SYS_CONTEXT can set a different default value depending on

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 162 of 177

USERENVretained for backward compatibility. Oracle Corporation recommends that you use the SYS_CONTEXT … function with the built-in USERENV namespace for current functionality. See SYS_CONTEXT for more … SYS_CONTEXT ENTRYID ENTRYID returns available auditing entry identifier. You cannot use this

Globalization Support Guide, 9i Release 2 (9.2.0.2)

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 … ); begin return 'language_id = sys_context(''userenv'', ''LANG'')'; end / DBMS_RLS.ADD_POLICY ('scott

Security Overview, 9i Release 2 (9.2.0.2)

Oracle9i Security Products and Features

Database-Enforced VPD Network AccessIP address of the client connection using the USERENV naming context as follows: SYS_CONTEXTSYS_CONTEXT('userenv', 'ip_address') to enforce that no records are returned unless the IP address matches … application role can also use the USERENV naming context (that is, SYS_CONTEXT('userenv', 'ip_address') ) to

Programmer's Guide, 9i Release 2 (9.2.0.2)

Managing Scalable Platforms

Externally Initialized Contextchapter on Establishing Security Oracle9i SQL Reference, the CREATE CONTEXT statement and the SYS_CONTEXT function

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

Implementing Application Security Policies

Introduction to Application Context Accessed Globallythe ID of the application session. From then on, every time the client invokes SYS_CONTEXT, only the … , when there is a SYS_CONTEXT('HR','RESPONSIBILITY') call, the database engine will match the client … SYS_CONTEXT call will only retrieve application context with a NULL client identifier, until the client … application context

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

Database Security Overview for Application Developers

Creating Secure Application Rolesinformation accessible through SYS_CONTEXT ('userenv', ). The accessible information indicates the way the … (sys_context('hr','role') = 'admin' ) then dbms_session.set_role('admin_role'); else dbms_session.set_role … by the proxy user 'SCOTT' */ if (sys_context('userenv','proxy_user') = 'SCOTT') then return TRUE

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE CLUSTER to CREATE JAVA, 3 of 12

CREATE CONTEXTcontext using the SYS_CONTEXT function. For example, suppose your emp_mgmt package has defined an … hr_org_secure_view AS SELECT * FROM employees WHERE employee_id = SYS_CONTEXT('hr_context', 'new_empno'); See Also: SYS_CONTEXT

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

Implementing Application Security Policies

Examples: Application Context Within a Fine-Grained Access Control Functioncustnum NUMBER; BEGIN SELECT cust_no INTO custnum FROM customers WHERE username = SYS_CONTEXT … attributes--such as session user--by using SYS_CONTEXT('userenv', session_primitive ). For more … = SYS_CONTEXT("order_entry", "cust_num")'; RETURN D_predicate; END Custnum_sec; END Oe_security; Step 4 … : SELECT * FROM Orders_tab WHERE

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

Implementing Application Security Policies

Ways to Use Application Context with Fine-Grained Access Control: SELECT * FROM Orders_tab to this: SELECT * FROM Orders_tab WHERE Custno = SYS_CONTEXT ('order_entry … as fine-grained security. Note that the SYS_CONTEXT function works much like a bind variable, but only if the SYS_CONTEXT arguments are constants.

Sample Schemas, 9i Release 2 (9.2.0.2)

Oracle9i Sample Schema Scripts

oe_views.sqld WHERE d.product_id (+) = i.product_id AND d.language_id (+) = sys_context('USERENV','LANG'); REM

Label Security Administrator's Guide, 9i Release 2 (9.2.0.2)

Implementing Policy Options and Labeling Functions

How Labeling Functions Workwhich the user is attached. There are many opportunities to use SYS_CONTEXT in this way. Note: If the

New Features, 9i Release 2 (9.2.0.2)

Oracle9i Database Release 1 (9.0.1) New Features

Development Features for Independent Software Vendorsmade more adaptive. Use of the SYS_CONTEXT function to generate default column values simplifies