Oracle7 Server Application Developer's Guide

Displaying Your DBMS Label

Your DBMS label is the label at which you are connected to Trusted Oracle. In OS MAC mode, this is always equivalent to the label of the database to which you are connected and always equivalent to your operating system session label. In DBMS MAC mode, this is the label with which you are connected to Trusted Oracle; because privileged users can alter their DBMS labels, this does not necessarily equal the label of your operating system session.

You can display your DBMS label in any of the following ways:

The USERENV function

The SHOW command in SQL*DBA

Displaying Your Label with the USERENV Function

To retrieve your DBMS label in any of the interactive tools produced by Oracle Corporation (including SQL*Plus and SQL*DBA), use the LABEL parameter of the USERENV function.

For example, assume that you are logged in to the database at SENSITIVE. To determine your DBMS label, enter

SELECT USERENV('label') FROM dual

which returns the following:

ROWLABEL
--------------------------------
SENSITIVE

Displaying Your Label with the Server Manager SHOW Command

To display your label in Server Manager, enter

SVRMGR>	SHOW LABEL

which returns the following:

Label                    SENSITIVE