Returns the name of the current user.
user
select user
------ dbo
user, a system function, returns the user’s name.
If the sa_role is active, you are automatically the Database Owner in any database you are using. Inside a database, the user name of the Database Owner is always “dbo”.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute user.
Documentation Transact-SQL Users Guide
Functions user_name