Returning Information about Current User

Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer Informix to Oracle Migration overview.

Ispirer SQLWays Database Migration Software
Returning Information about Current User

This subsection describes built-in functions that return the name of the current user connected to the database.
TABLE 66. Returning Information about Current User
Database

Syntax

Description
Oracle
USER 
Returns the name of the user currently connected to the database.

Returned type: varchar2

Remarks: Cannot be used as a condition for the CHECK constraints.
Informix
USER 
The USER operator returns the name of the user currently connected to the database.

Returned type: VARCHAR.

Database	Syntax	Description
Oracle	USER	Returns the name of the user currently connected to the database. Returned type: varchar2 Remarks: Cannot be used as a condition for the CHECK constraints.
Informix	USER	The USER operator returns the name of the user currently connected to the database. Returned type: VARCHAR.