Security USER_NAME SQL function

1. Usage of USER_NAME

SQL Server Query 1

            
 SELECT USER_NAME(3) AS UserName  

 UNION ALL  

 SELECT USER_NAME() AS UserName  

 UNION ALL  

 SELECT name AS UserName FROM sys.database_principals WHERE name = USER_NAME(1)  

 UNION ALL  

 SELECT name AS UserName FROM sysusers WHERE name = USER_NAME(1); 

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new USER_NAME(3), "UserName")  

     .UnionAll(new SqlQueryBuilder().Select().Column(new USER_NAME(), "UserName"))  

     .UnionAll(new SqlQueryBuilder()  

         .Select()  

         .Column("name", "UserName")  

         .From("sys.database_principals")  

         .Where(new Where(new Column("name").Equale(new USER_NAME(1))))  

     )  

     .UnionAll(new SqlQueryBuilder().Select()  

         .Column("name","UserName")  

         .From("sysusers")  

         .Where(new Where(new Column("name").Equale(new USER_NAME(1))))  

     )  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT USER_NAME(@pMAIN_2507192019003058950) AS UserName
UNION ALL
SELECT USER_NAME() AS UserName
UNION ALL
SELECT name AS UserName
FROM sys.database_principals
WHERE name = USER_NAME(@pMAIN_2507192019003058951)
UNION ALL
SELECT name AS UserName
FROM sysusers
WHERE name = USER_NAME(@pMAIN_2507192019003058952);


            
        

Parameters (If used)

Query Results 1: