Post reply

Retrieve User Network Name

  • 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.

  • 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/

  • September 16, 2011 at 9:28 am

    #1382620

    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!

  • September 16, 2011 at 10:53 am

    #1382676

    I was afraid that would be the case.

    Thanks.

  • September 17, 2011 at 4:42 pm

    #1382995

    NO you can't get that info for SQL Server logins..

    Thank You,

    Best Regards,

    SQLBuddy

  • September 18, 2011 at 9:52 am

    #1383081

    you should be able to get the IP address of the client this may help to narrow the user down

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • September 19, 2011 at 1:44 pm

    #1383468

    Perry Whittle (9/18/2011)

    you should be able to get the IP address of the client this may help to narrow the user down

    Ya, I bust people for using an sql account by getting the host name which is assigned to a particular user where I work.

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

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