How do you get the sql server username of the currently executing command in a CLR Trigger?

Question

I know that SqlContext.WindowsIdentity returns the current user that is executing the command (in a CLR trigger), however, this only works for windows authenticated users. How do I get the username if it's a sql server user instead? Any help is appreciated.

Cᴏʀʏ · Accepted Answer · 2014-05-09 14:04:20Z

11

Try using SUSER_NAME() function in SQL server. This will return the current user.

edited May 9, 2014 at 14:04

Cᴏʀʏ

108k20 gold badges169 silver badges201 bronze badges

answered Jun 29, 2009 at 18:07

Raj

10.9k2 gold badges47 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Musikero31 · Accepted Answer · 2010-09-22 03:32:15Z

5

Try using SYSTEM_USER.

SELECT SYSTEM_USER

answered Sep 22, 2010 at 3:32

Musikero31

3,1726 gold badges44 silver badges65 bronze badges

Comments

Dima · Accepted Answer · 2011-05-31 06:59:04Z

0

You can use context of the current connection and get all you need from the connection object.

Like this (in C#):

SqlConnection connection = new SqlConnection("context connection=true");

answered May 31, 2011 at 6:59

Dima

5571 gold badge4 silver badges16 bronze badges

Collectives™ on Stack Overflow

How do you get the sql server username of the currently executing command in a CLR Trigger?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related