Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check which user who is processing current stored procedure

Status
Not open for further replies.
lechuck

lechuck

Programmer
Sep 4, 2000
26
SE
I have a stored procedure that i need to check which SQL-user who is processing the current procedure.
Is this possible and how do I accomplish that?
 
Sort by date Sort by votes
select current_user, system_user

system_user will return the windows user if windows authentication is used, or the SQL Login id of the user if sql server authentication is used

Hope this helps
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
1K
gmmastros
gmmastros
ahmedsa2018
  • Locked
  • Question
the goal mfrom asking question is t
Replies
0
Views
93
ahmedsa2018
ahmedsa2018
ahmedsa2018
  • Locked
  • Question
How to get monther per part id from last date to current date and include remaining date ? 1
Replies
7
Views
168
JohnBayne
JohnBayne
barim
  • Locked
  • Question
Compare Dates With Current Date
Replies
3
Views
80
barim
barim
peac3
  • Locked
  • Question
Gaps and islands
Replies
8
Views
230
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top