Show which login a user is using to access database 1

[spangeman]

SQL 2000 Question - Logins / Groups / Users

Hi, I tried some googling of this but didn't get very far.


I have a user accessing the database via membership of a Windows NT group. The user should have read-only access to the database (as defined in their Database User) but they are actually able to read and write.

My suspicion is that the user is actually accessing the database through another group or login. It may be that they are members of multiple NT groups. I am not in control of this so I can't be certain.

Is there a stored procedure or some method I could use to show how the user is accessing the database? I.e. show which login or group and database user they are currently using.

Regards
Spangeman

 

[SQLDenis]

take a look at these functions

select suser_sname(), user_name(),host_name(),system_user

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQL Server Programming Hacks

 

[spangeman]

Thank you, thats perfect.