Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Security

SQL 2005 LOGS display only Group Names How to track individual users?

Trying to track the users who are logged in and making changes to my database. I have granted permission through the Windows Groups and the log displays the group names and not the user names. Is there something to set to display the user and the group?

Thanks

Amanda

[408 byte] By [Amanda1234] at [2008-1-8]
«« TCP/UDP Connections through the internet
»» Extract complete WordprocessingML document from package instance.
# 1

Which log are you referring to? If you do your own auditing, functions like suser_name() will return the user name, not the group name. Also, this information is kept track of in the user token, which can be examined via sys.login_token and sys.user_token.

Thanks

Laurentiu

LaurentiuCristofor at 2007-10-2 > top of Msdn Tech,SQL Server,SQL Server Security...
# 2

Thanks for responding.

I am looking at the log in SQL Manager under

Management - SQL Server Logs - Current

Is there a way to run these functions automaticaly everytime a user logs in, and report it to the log?

Thanks

Amanda

Amanda1234 at 2007-10-2 > top of Msdn Tech,SQL Server,SQL Server Security...
# 3

The Server Application log and the SQL Logs, 'should' all be using the Users Login Name -NOT the Windows Group Name.

Do you have a 'group' of users, all logging in with the same UserName/Password?

ArnieRowland at 2007-10-2 > top of Msdn Tech,SQL Server,SQL Server Security...
SQL Server
SQL Server Security

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified