Auditing Tool

The department here is looking for a 3rd party auditing tool that can monitor
the SQL 2000 data base for changed, deleted or added records. One utility
available is Apex SQL
Log that costs about $700.00. Anyone know of this or any other such utility?
Thanks for everyone being there to help.Hi,
See Logexplorer from www.Lumigent.com
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:86F241F5-03E4-4491-ACEF-5AC5943628D8@.microsoft.com...
> The department here is looking for a 3rd party auditing tool that can
> monitor
> the SQL 2000 data base for changed, deleted or added records. One utility
> available is Apex SQL
> Log that costs about $700.00. Anyone know of this or any other such
> utility?
> Thanks for everyone being there to help.
>

Auditing Select Statements

Hello,
I need to find out if there is a way to audit selects against a certain
table. I know you can use triggers to monitor inserts, updates and
deletes but is there a way to monitor when someone selects specific
data? Thanks!
Rachael
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!Go to Lumigents web site... www.lumigent.com... I beleive they have an
auditing tool that does what you wish..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rachael" <rachael_faber@.hotmail.com> wrote in message
news:eu0FLAVVEHA.584@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I need to find out if there is a way to audit selects against a certain
> table. I know you can use triggers to monitor inserts, updates and
> deletes but is there a way to monitor when someone selects specific
> data? Thanks!
> Rachael
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!

Auditing Select Statements

Hello,
I need to find out if there is a way to audit selects against a certain
table. I know you can use triggers to monitor inserts, updates and
deletes but is there a way to monitor when someone selects specific
data? Thanks!
Rachael
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Go to Lumigents web site... www.lumigent.com... I beleive they have an
auditing tool that does what you wish..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rachael" <rachael_faber@.hotmail.com> wrote in message
news:eu0FLAVVEHA.584@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I need to find out if there is a way to audit selects against a certain
> table. I know you can use triggers to monitor inserts, updates and
> deletes but is there a way to monitor when someone selects specific
> data? Thanks!
> Rachael
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!

Auditing Select Statements

Hello,
I need to find out if there is a way to audit selects against a certain
table. I know you can use triggers to monitor inserts, updates and
deletes but is there a way to monitor when someone selects specific
data? Thanks!
Rachael
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!Go to Lumigents web site... www.lumigent.com... I beleive they have an
auditing tool that does what you wish..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rachael" <rachael_faber@.hotmail.com> wrote in message
news:eu0FLAVVEHA.584@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I need to find out if there is a way to audit selects against a certain
> table. I know you can use triggers to monitor inserts, updates and
> deletes but is there a way to monitor when someone selects specific
> data? Thanks!
> Rachael
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!

auditing logins in Analysis server

Hello,

Can anyone tell me how to monitor logins/logouts to Analysis Services
databases? I use Profiler to do so in SQL, but cannot find a way to do
it in AS.

Thanks,

Tim

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"tim groulx" <timgru@.verizon.net> wrote in message
news:416308d3$0$26169$c397aba@.news.newsgroups.ws.. .
> Hello,
> Can anyone tell me how to monitor logins/logouts to Analysis Services
> databases? I use Profiler to do so in SQL, but cannot find a way to do
> it in AS.
> Thanks,
> Tim
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

There's a registry key you can enable - see "Monitoring user access" in this
white paper:

http://www.microsoft.com/technet/pr...n/anservog.mspx

Simon

auditing logins

SQL 2k, Windows authentication only
I'd like to be able to monitor when a particular developer attempts to
login to sql server. (successful or not)
Ideally, I'd like an alert to fire when that user logs in or attempts
and fails to log in. How can I set up an alert for successful login?
Is the auditing information stored in tables? I could schedule a job to
select for that developer every hour or so.
I know the log files are written to disk, so should I just write a small
program to search through these?
I appreciate any/all suggestions
Tom
E-mail correspondence to and from this address may be subject to the
North Carolina Public Records Law and may be disclosed to third parties.
Login auditing is done in the Windows Security event log. There is an
option to set it for successful logins, failed logins or both.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tom W" <Tom.Williams@.DontSpamMencmail.net> wrote in message
news:ur3wDW12GHA.3516@.TK2MSFTNGP06.phx.gbl...
> SQL 2k, Windows authentication only
> I'd like to be able to monitor when a particular developer attempts to
> login to sql server. (successful or not)
> Ideally, I'd like an alert to fire when that user logs in or attempts and
> fails to log in. How can I set up an alert for successful login?
> Is the auditing information stored in tables? I could schedule a job to
> select for that developer every hour or so.
> I know the log files are written to disk, so should I just write a small
> program to search through these?
> I appreciate any/all suggestions
> Tom
> --
>
> E-mail correspondence to and from this address may be subject to the
> North Carolina Public Records Law and may be disclosed to third parties.

auditing logins

SQL 2k, Windows authentication only
I'd like to be able to monitor when a particular developer attempts to
login to sql server. (successful or not)
Ideally, I'd like an alert to fire when that user logs in or attempts
and fails to log in. How can I set up an alert for successful login?
Is the auditing information stored in tables? I could schedule a job to
select for that developer every hour or so.
I know the log files are written to disk, so should I just write a small
program to search through these?
I appreciate any/all suggestions
Tom
--
E-mail correspondence to and from this address may be subject to the
North Carolina Public Records Law and may be disclosed to third parties.Login auditing is done in the Windows Security event log. There is an
option to set it for successful logins, failed logins or both.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tom W" <Tom.Williams@.DontSpamMencmail.net> wrote in message
news:ur3wDW12GHA.3516@.TK2MSFTNGP06.phx.gbl...
> SQL 2k, Windows authentication only
> I'd like to be able to monitor when a particular developer attempts to
> login to sql server. (successful or not)
> Ideally, I'd like an alert to fire when that user logs in or attempts and
> fails to log in. How can I set up an alert for successful login?
> Is the auditing information stored in tables? I could schedule a job to
> select for that developer every hour or so.
> I know the log files are written to disk, so should I just write a small
> program to search through these?
> I appreciate any/all suggestions
> Tom
> --
>
> E-mail correspondence to and from this address may be subject to the
> North Carolina Public Records Law and may be disclosed to third parties.

auditing logins

SQL 2k, Windows authentication only
I'd like to be able to monitor when a particular developer attempts to
login to sql server. (successful or not)
Ideally, I'd like an alert to fire when that user logs in or attempts
and fails to log in. How can I set up an alert for successful login?
Is the auditing information stored in tables? I could schedule a job to
select for that developer every hour or so.
I know the log files are written to disk, so should I just write a small
program to search through these?
I appreciate any/all suggestions
Tom
E-mail correspondence to and from this address may be subject to the
North Carolina Public Records Law and may be disclosed to third parties.Login auditing is done in the Windows Security event log. There is an
option to set it for successful logins, failed logins or both.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tom W" <Tom.Williams@.DontSpamMencmail.net> wrote in message
news:ur3wDW12GHA.3516@.TK2MSFTNGP06.phx.gbl...
> SQL 2k, Windows authentication only
> I'd like to be able to monitor when a particular developer attempts to
> login to sql server. (successful or not)
> Ideally, I'd like an alert to fire when that user logs in or attempts and
> fails to log in. How can I set up an alert for successful login?
> Is the auditing information stored in tables? I could schedule a job to
> select for that developer every hour or so.
> I know the log files are written to disk, so should I just write a small
> program to search through these?
> I appreciate any/all suggestions
> Tom
> --
>
> E-mail correspondence to and from this address may be subject to the
> North Carolina Public Records Law and may be disclosed to third parties.

Audit Question

Is there a way I can monitor who is using EM to open tables?
Suppose I have a database with a table(s) where I keep the answers to questi
ons on a test, or answers to a game a company is running on an intranet, how
do I know if people with sa permissions are going in via the back door to l
ook/retrieve answers?
Thanx!You could use the Profiler on the database and monitor queries, spid's etc.
This can all
be logged to a table.
"JLS" <jlshoop@.hotmail.com> wrote in message news:eiWh$z1wEHA.1300@.TK2MSFTNG
P14.phx.gbl...
Is there a way I can monitor who is using EM to open tables?
Suppose I have a database with a table(s) where I keep the answers to questi
ons on a test, or answers to a game a company is running on an intranet, how
do I know if people with sa permissions are going in via the back door to l
ook/retrieve answers?
Thanx!|||I also forgot to add... the sa password should really be kept under wraps a
nd in
the hands of people on a need to know basis.
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message news:eUYK$V2wEH
A.1524@.TK2MSFTNGP09.phx.gbl...
You could use the Profiler on the database and monitor queries, spid's etc.
This can all
be logged to a table.
"JLS" <jlshoop@.hotmail.com> wrote in message news:eiWh$z1wEHA.1300@.TK2MSFTNG
P14.phx.gbl...
Is there a way I can monitor who is using EM to open tables?
Suppose I have a database with a table(s) where I keep the answers to questi
ons on a test, or answers to a game a company is running on an intranet, how
do I know if people with sa permissions are going in via the back door to l
ook/retrieve answers?
Thanx!|||The best solution would be to put that database on a secured installation
where you controlled who had sa access.
The problem with any sort of auditing solution is that the people you are
auditing are GOD within the system, which means they have the power to
subvert your tracking.
Sincerely,
Anthony Thomas
"Armando Prato" wrote:

> You could use the Profiler on the database and monitor queries, spid's etc
. This can all
> be logged to a table.
>
> "JLS" <jlshoop@.hotmail.com> wrote in message news:eiWh$z1wEHA.1300@.TK2MSFT
NGP14.phx.gbl...
> Is there a way I can monitor who is using EM to open tables?
> Suppose I have a database with a table(s) where I keep the answers to qu
estions on a test, or answers to a game a company is running on an intranet,
how do I know if people with sa permissions are going in via the back door
to look/retrieve answers?
> Thanx!|||Exactly!!! These are my peers, network guys in my department. But I want
the game to be fair, if they can just go into the tables via the back door
then that's really not fair to the rest of the people playing.
To address the comment about the sa password only being given on a need to
know, it is.
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:006309CB-AB18-4C59-8B35-75903AA6ECC2@.microsoft.com...[vbcol=seagreen]
> The best solution would be to put that database on a secured installation
> where you controlled who had sa access.
> The problem with any sort of auditing solution is that the people you are
> auditing are GOD within the system, which means they have the power to
> subvert your tracking.
> Sincerely,
>
> Anthony Thomas
>
> "Armando Prato" wrote:
>
etc. This can all[vbcol=seagreen]
news:eiWh$z1wEHA.1300@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
questions on a test, or answers to a game a company is running on an
intranet, how do I know if people with sa permissions are going in via the
back door to look/retrieve answers?[vbcol=seagreen]|||You could always change the 'sa' password yourself prior to the
game commencing. I am assuming that this isn't a production
server. At least I hope it's not ;)
"JLS" <jlshoop@.hotmail.com> wrote in message
news:uPoodP3wEHA.3612@.tk2msftngp13.phx.gbl...
> Exactly!!! These are my peers, network guys in my department. But I want
> the game to be fair, if they can just go into the tables via the back door
> then that's really not fair to the rest of the people playing.
> To address the comment about the sa password only being given on a need to
> know, it is.
>
> "AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
> news:006309CB-AB18-4C59-8B35-75903AA6ECC2@.microsoft.com...
installation[vbcol=seagreen]
are[vbcol=seagreen]
> etc. This can all
> news:eiWh$z1wEHA.1300@.TK2MSFTNGP14.phx.gbl...
to[vbcol=seagreen]
> questions on a test, or answers to a game a company is running on an
> intranet, how do I know if people with sa permissions are going in via the
> back door to look/retrieve answers?
>

Audit Question

Is there a way I can monitor who is using EM to open tables?
Suppose I have a database with a table(s) where I keep the answers to questions on a test, or answers to a game a company is running on an intranet, how do I know if people with sa permissions are going in via the back door to look/retrieve answers?
Thanx!
You could use the Profiler on the database and monitor queries, spid's etc. This can all
be logged to a table.
"JLS" <jlshoop@.hotmail.com> wrote in message news:eiWh$z1wEHA.1300@.TK2MSFTNGP14.phx.gbl...
Is there a way I can monitor who is using EM to open tables?
Suppose I have a database with a table(s) where I keep the answers to questions on a test, or answers to a game a company is running on an intranet, how do I know if people with sa permissions are going in via the back door to look/retrieve answers?
Thanx!
|||I also forgot to add... the sa password should really be kept under wraps and in
the hands of people on a need to know basis.
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message news:eUYK$V2wEHA.1524@.TK2MSFTNGP09.phx.gbl...
You could use the Profiler on the database and monitor queries, spid's etc. This can all
be logged to a table.
"JLS" <jlshoop@.hotmail.com> wrote in message news:eiWh$z1wEHA.1300@.TK2MSFTNGP14.phx.gbl...
Is there a way I can monitor who is using EM to open tables?
Suppose I have a database with a table(s) where I keep the answers to questions on a test, or answers to a game a company is running on an intranet, how do I know if people with sa permissions are going in via the back door to look/retrieve answers?
Thanx!
|||The best solution would be to put that database on a secured installation
where you controlled who had sa access.
The problem with any sort of auditing solution is that the people you are
auditing are GOD within the system, which means they have the power to
subvert your tracking.
Sincerely,
Anthony Thomas
"Armando Prato" wrote:

> You could use the Profiler on the database and monitor queries, spid's etc. This can all
> be logged to a table.
>
> "JLS" <jlshoop@.hotmail.com> wrote in message news:eiWh$z1wEHA.1300@.TK2MSFTNGP14.phx.gbl...
> Is there a way I can monitor who is using EM to open tables?
> Suppose I have a database with a table(s) where I keep the answers to questions on a test, or answers to a game a company is running on an intranet, how do I know if people with sa permissions are going in via the back door to look/retrieve answers?
> Thanx!
|||Exactly!!! These are my peers, network guys in my department. But I want
the game to be fair, if they can just go into the tables via the back door
then that's really not fair to the rest of the people playing.
To address the comment about the sa password only being given on a need to
know, it is.
"AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
news:006309CB-AB18-4C59-8B35-75903AA6ECC2@.microsoft.com...[vbcol=seagreen]
> The best solution would be to put that database on a secured installation
> where you controlled who had sa access.
> The problem with any sort of auditing solution is that the people you are
> auditing are GOD within the system, which means they have the power to
> subvert your tracking.
> Sincerely,
>
> Anthony Thomas
>
> "Armando Prato" wrote:
etc. This can all[vbcol=seagreen]
news:eiWh$z1wEHA.1300@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
questions on a test, or answers to a game a company is running on an
intranet, how do I know if people with sa permissions are going in via the
back door to look/retrieve answers?[vbcol=seagreen]
|||You could always change the 'sa' password yourself prior to the
game commencing. I am assuming that this isn't a production
server. At least I hope it's not ;)
"JLS" <jlshoop@.hotmail.com> wrote in message
news:uPoodP3wEHA.3612@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Exactly!!! These are my peers, network guys in my department. But I want
> the game to be fair, if they can just go into the tables via the back door
> then that's really not fair to the rest of the people playing.
> To address the comment about the sa password only being given on a need to
> know, it is.
>
> "AnthonyThomas" <AnthonyThomas@.discussions.microsoft.com> wrote in message
> news:006309CB-AB18-4C59-8B35-75903AA6ECC2@.microsoft.com...
installation[vbcol=seagreen]
are[vbcol=seagreen]
> etc. This can all
> news:eiWh$z1wEHA.1300@.TK2MSFTNGP14.phx.gbl...
to
> questions on a test, or answers to a game a company is running on an
> intranet, how do I know if people with sa permissions are going in via the
> back door to look/retrieve answers?
>