Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

CURRENT_USER SQL Function

Syntax

CURRENT_USER

Description

CURRENT_USER returns a character string identifier for the database user as specified in the current connection. It returns a character in the database character set. If the current connection did not specify an user, CURRENT_USER returns the login name as determined by the host operating system.

FairCom DB SQL statements can refer to CURRENT_USER anywhere they can refer to a character string expression.

Example

ISQL>SELECT CURRENT_USER FROM admin.syscalctable ;

FRED

---------------

fred

1 record selected

Note: SQL-99 compatible

TOCIndex