Showing posts with label sys_context. Show all posts
Showing posts with label sys_context. Show all posts
Thursday, August 31, 2023

More on how to display the current container in a multitenant database

›
My listener is listening for connections to a service called "myservice1", which runs out of the pluggable database "pdb1...
Monday, March 16, 2020

How to modify a unified auditing policy to make exceptions based on login information

›
The audit policy had been created as follows: create audit policy all_select_policy actions select; Here is how you can alter an existing...
Wednesday, September 4, 2019

How to create a proxy authenticated user in Oracle

›
Create a general user for authentication: CREATE USER APP_POOL IDENTIFIED BY app_pool_users123 DEFAULT TABLESPACE USERS TEMPORARY TABL...
Thursday, March 7, 2019

How to use dbms_session to set client_identifier in your session

›
Logged in as user scott, I set the following in my session: EXEC DBMS_SESSION.SET_IDENTIFIER (client_id=>'vegardk'); Verify t...

How to create a range-list partitioned table, using interval partitioning and subpartition template

›
Note: I am placing the subpartitions, the initial partition, the table definition itself, and the LOB segments, in different tablespaces s...
Wednesday, June 13, 2018

Display the current locks in a tree-like fashion

›
Oracle provides some built-in scripts and views that can be used to monitor locks in the database http://docs.oracle.com/database/121/A...
Wednesday, August 9, 2017

How to use the 12c Privilege Analysis feature

›
One of the many New features in Oracle 12c is the ability to perform analysis of privileges that are assigned to a user. Privilege Analys...
Sunday, December 18, 2016

How to display the current container in an Oracle multitenant database

›
You can display the current container your session is currently connected to using three different methods. First, connect to either the ...
3 comments:
Thursday, February 4, 2016

How to create and start a service with dbms_service

›
Create the service. The first parameter name is the service name, can be up to 64 characters long. The second parameter is the network na...
3 comments:
Friday, January 10, 2014

How to use SYS_CONTEXT to display user information

›
Oracle provides a built-in namespace called USERENV, which describes the current session. The function SYS_CONTEXT can be used to return ...
Wednesday, October 30, 2013

How to create a DDL trigger in a schema

›
CREATE TABLE AUDIT_DDL ( d date, OSUSER varchar2(255), CURRENT_USER varchar2(255), HOST varchar2(255), TERMINAL varchar2(255), owner...