Retrieve User Network Name

Question

Post reply

Retrieve User Network Name

troe_atl

SSC Eights!

Points: 987
More actions
September 16, 2011 at 8:55 am

#243291

Hello everyone.

Is it possible to retrieve a Windows network name while logged into SQL Server using the sa account? I've tried every function in BOL related to security, but the ones I thought would work only returned "sa" instead of the network name of the current machine. Any ideas?

Thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

FibRock Right there with Babe Points: 726 More actions · Answer 1

FibRock

Right there with Babe

Points: 726

September 16, 2011 at 9:10 am

#1382607

Yes, its possible. Try suser_name() instead of user_name.

Example:

select

user_name() [user_name]

,suser_name() [suser_name]

Steve
http://stevefibich.net
http://utilitydb.codeplex.com/

Lowell SSC Guru Points: 323482 More actions · Answer 2

however, if htey connected using a SQL login, the windows username is not available in any way, shape or form, unless you specifically code an application to get the information and pass it along.

SQL logins do not contain any info from Windows.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!