Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
walnut
Starting Member
2 Posts |
 Posted - 2006-07-23 : 23:39:46
|
Hi. From a security standpoint,I was wondering how much details can Syslog [real-time logging] provide for administrators?I understand Syslog can typically log system errors eg. link errors etc.Is Syslog capable of logging the following actions:1. Creation of accounts2. Creation of views, tables3. Execution of commands, procedures etc...Is there a way to tune the details that Syslog can register?Or is there a better alternative other than Syslog that can provide Real-time logging and provide the details of the above-mentioned actions?Thank you very much. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-24 : 00:04:22
|
| where is syslog located?if you're referring to sql2000 and the sql logs, then no, you need to have an auditing tool or to turn profiler on to capture these type of actionsHTH--------------------keeping it simple... |
 |
|
|
walnut
Starting Member
2 Posts |
Posted - 2006-08-10 : 03:53:31
|
| Hi.can anyone recommend an auditing tool[enterprise or freeware] that can fulfill the following 2 conditions?1. Capable of logging the following actions: - Creation of accounts - Creation of views, tables - Execution of commands, procedures etc...AND2. Allows real-time export of the above logs to a separate server so that the administrator does not have the capability to delete the logs?Thank you very much. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-08-10 : 06:02:03
|
| In SQL 2005, you can create triggers to action some of this stuff yourself. Execution of procedures can be logged by having the procedures log their invocation. Search member "nr"s website I think for samples. |
|
|
|
|
|
|
How much details can Syslog provide?