4.9.2.81 SUSER_NAME function (extension)

Syntax

SUSER_NAME ( [user_id] )

Description

The scalar function SUSER_NAME returns the user login name for the user_id specified in the input argument. If no user_id is specified, SUSER_NAME returns the name of the current user.

This function provides compatibility with the Sybase SQL Server function suser_name. It is identical to the USER_NAME function.

Example

 select suser_name() from systpe.syscalctable;
SUSER_NAME
----------
searle
1 record selected
 select suser_name(104) from systpe.syscalctable;
SUSER_NAME(104)
---------------
dbp
1 record selected
  select id, tbl, owner from systpe.systables
   1  where owner = suser_name();
          ID TBL                                OWNER
          -- ---                                -----
          41 test                               searle
          42 t2                                 searle
          43 t1                                 searle

3 records selected