Quote:
Originally Posted by devikacs
how do i know who accessed/ran a procedure or query
You can use a tool such as the SQL Profiler to filter queries as they happen, or you will have to modify your stored procedures to keep a history of who runs it. You could also build history functionality into your front end.
Other than that, I do not know of a way to keep track of people logging in directly to your server and executing queries.|||
Quote:
Originally Posted by Motoma
You can use a tool such as the SQL Profiler to filter queries as they happen, or you will have to modify your stored procedures to keep a history of who runs it. You could also build history functionality into your front end.
Other than that, I do not know of a way to keep track of people logging in directly to your server and executing queries.
thanks. i want to make a log of who accessed, so wanted to know if there's any way i can detect when some user accesses a database, or runs a query of his own
No comments:
Post a Comment