Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

SYSTEM_USER() Function in SQL Server

  • Last Updated : 19 Jan, 2021

SYSTEM_USER() function :
This function in SQL Server is used to return the current user’s login name.

Features :

  • This function is used to find the current user’s login name.
  • This function comes under Advanced Functions.
  • This function doesn’t accept any parameter.

Syntax :

SYSTEM_USER;

Parameter :
This method doesn’t accept any parameter.

Returns :
It returns the current user’s login name.



Example-1 :
Using SYSTEM_USER() function and getting the current user’s login name.

SELECT SYSTEM_USER;

Output :

nidhi

Example-2 :
Using SYSTEM_USER as a default value in the below example and getting the output.
 

CREATE TABLE user01
(  
user_id int IDENTITY(100, 2) NOT NULL,
customer_id int NOT NULL,
user_name char(50) NOT NULL DEFAULT SYSTEM_USER
);  
INSERT user01(customer_id)  
VALUES (101);

INSERT user01(customer_id)  
VALUES (102);

SELECT * FROM user01; 

Output :

 

S.No.user_idcustomer_iduser_name
1100101nidhi
2101102nidhi

Here, firstly you need to create a table then insert values into it then generate the required output using SYSTEM_USER function as a default value.

Note : For running above code use sql server compiler, you can also use a online compiler.

Example-3 :
Using SYSTEM_USER() function and impersonating user ‘Geek’.
 

SELECT SYSTEM_USER;  
EXECUTE AS USER = 'Geek';  
SELECT SYSTEM_USER;  

Output :

nidhi
Geek

Here, we are impersonating user as ‘Geek’, then calling SYSTEM_USER function to get the current user’s name.

Example-4 :
Using SYSTEM_USER() function for impersonating user ‘Geek’ then again reverting the code to get the previous current user.
 

SELECT SYSTEM_USER;  
EXECUTE AS USER = 'Geek';  
SELECT SYSTEM_USER;  
REVERT;
SELECT SYSTEM_USER;

Output :

nidhi
Geek
nidhi

Application :
This function is used to find the current user’s login name.
 

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!