brgdotnet
asked on
Are sql server transactions logged on a per user basis
Let's say I have a server that people log into. They then may access an instance of sql server 2008 on that server. Is there a way to tell who ran a certain stored procedure? Is it logged somewhere. User, what time etc>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I need to see who the last person was who ran a certain stored procedure. Not for a bad reason. I would just like to know if that is possible, and how to do it?
Single shared account you can not. Making sure SQL logs logins you will at least know from where someone logged in. Who runs an sp is more difficult. Adding record keeping to the sp I.e. When it was run will at least help you narrow the window.
Setting up an interface web based, through which users would need to login and trigger function is the only way other than reconfiguring the means of access to windows authentication and adjusting the rights.......
Not too difficult, but you could setup a windows group with a specific set of rights into which you will add the users.
The change they will make is to use integrated security /windows auth versus SQL logins.
With this, I believe the sp can record who ran it.
Setting up an interface web based, through which users would need to login and trigger function is the only way other than reconfiguring the means of access to windows authentication and adjusting the rights.......
Not too difficult, but you could setup a windows group with a specific set of rights into which you will add the users.
The change they will make is to use integrated security /windows auth versus SQL logins.
With this, I believe the sp can record who ran it.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER