User Guide

9.9.3
- 9.9.4
- 9.9.2
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Rewrite Select List Example

The following example is a simple method you can use to view the values of the global variable for a session.

Create a security rule that rewrites an SQL request, such as

SELECT * FROM ALL_GLOBALS

, and replaces the SQL request with the following query, based on the database management system type:

Oracle

select '\(CLIENT_IP)' "Client IP", '\(AUTH_USERNAME)' "Username",'\(AUTH_SID)' "OS User",'\(AUTH_MACHINE)' "Host name", '\(AUTH_TERMINAL)' "OS user name", '\(AUTH_SERIAL_NUM)' "SERIAL#", '\(AUTH_PROGRAM_NM)' "Program",'\(AUTH_DATABASE_NAME)' "DDM Name",'\(AUTH_SESSION_ID)' "SID", '\(AUTH_CURRENT_DATABASE)' "Current Database" from dual

IBM Db2

select '\(CLIENT_IP)' "Client IP", '\(AUTH_USERNAME)' "Username",'\(AUTH_SID)' "OS User",'\(AUTH_MACHINE)' "Host name", '\(AUTH_TERMINAL)' "OS user name", '\(AUTH_SERIAL_NUM)' "SERIAL#", '\(AUTH_PROGRAM_NM)' "Program",'\(AUTH_DATABASE_NAME)' "DDM Name",'\(AUTH_SESSION_ID)' "SID", '\(AUTH_CURRENT_DATABASE)' "Current Database" from sysibm.sysdummy1

Microsoft SQL Server

select '\(CLIENT_IP)' "Client IP", '\(AUTH_USERNAME)' "Username",'\(AUTH_SID)' "OS User",'\(AUTH_MACHINE)' "Host name", '\(AUTH_TERMINAL)' "OS user name", '\(AUTH_SERIAL_NUM)' "SERIAL#", '\(AUTH_PROGRAM_NM)' "Program",'\(AUTH_DATABASE_NAME)' "DDM Name",'\(AUTH_SESSION_ID)' "SID", '\(AUTH_CURRENT_DATABASE)' "Current Database"

Rename Saved Search

Table of Contents

User Guide

User Guide

Rewrite Select List Example

Rewrite Select List Example