SQL Server/T-SQL Tutorial/User Role/USER NAME
USER_NAME Function returns the name of user logged into the database. The syntax for the USER_NAME function is as follows:
<source lang="sql">
4> 5> 6> select USER_NAME() 7> GO
dbo (1 rows affected) 1></source>