Category: ASE: Functions: User, Login and Role Functions

user

The user function user returns the user of a database in the current session. The function "user" is the only function which does not require round brackets "()" Instead of the "user" function, user_name() can be used, too. Users with an active sa_role are automatically "database owner" (dbo) in every database.

Syntax of the User Function user

    user
    

Example for the User Function user

    select user

    go

    -----

    dbo
    

Returns the name of the database user in the current session.

setuser,
sp_addalias,
sp_addgroup,
sp_addlogin,
sp_adduser,
sp_changegroup,
sp_configure "check password for digit",
sp_configure "minimum failed logins",
sp_configure "minimum password length",
sp_configure "systemwide password expiration",
sp_displaylogin,
sp_dropalias,
sp_dropgroup,
sp_droplogin,
sp_dropuser,
sp_helpgroup,
sp_helpuser,
sp_locklogin,
sp_modifylogin,
sp_password,

See also:

ASE T-SQL - Aggregate Functions,
ASE T-SQL - User,
mut_excl_roles(),
proc_role(),
role_contain(),
role_id(),
role_name(),
show_role(),
suser_id(),
suser_name(),
user_id(),
user_name(),
valid_name(),
valid_user().