CODEWITHSUNDEEP
sqlsql-server
h33
h33

Reputation: 1344

SQL Server: CURRENT_USER, SYSTEM_USER, SESSION_USER

What is the difference between these? They all sound the same to me.

Upvotes: 1

Views: 812

Answers (1)

i10101
i10101

Reputation: 36

System_user -> the current windows user

Current_user -> Current SQL server User

Session_user -> returns the user name of the current context in the current database

Upvotes: 2

Related Questions