Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imranswork
Starting Member
1 Post |
 Posted - 2014-04-16 : 03:53:22
|
| Dear All,User is login to the application using SQL Server Autentication method. I want to get his windows OS username to log in one of my security trigger.All of the following:SUSER_NAME(), SYSTEM_USER AS OSUser, SUSER_SNAME() AS SuserSName, ORIGINAL_LOGIN() As OriginalLogin, USER_NAME() as UserNameAre returning database user name, while i need OS username.Kindly helpimran |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-06-10 : 03:29:12
|
| i think you can also get the ip of the systemJaveed Ahmed |
 |
|
|
|
|
|
Get windows username in trigger