You are here: Re: Auditing user and security related activities in SQLServer « MsSQL Server « IT news, forums, messages
Re: Auditing user and security related activities in SQLServer

Posted by Oscar Santiesteban Jr. on 07/22/05 04:53

Take a look at www.lumigent.com and their product called Entegra.
Depening on how much you value your time or how much the company your work
for is willing to spend, this may be a "no-brainer" decision. It does most
of what you want to do.
It is priced per processor, ie 1-2 cpu or 3-4 cpu. You can even monitor
"select" statements.

Oscar

"byrocat" <bdealhoy@sympatico.ca> wrote in message
news:1121968677.798082.274370@g14g2000cwa.googlegroups.com...
> On the other database types, there is an audit capability in that you
> record such items as
> failed login attempts
> attemtped access to tables user is not authroized to
> changes to databse schema
> changes to permissions
> changes to logins (add, delete, lock, unlock, passwrod reset)
>
> All I can find in the SQLServer documentation is the reference to
> tracking failed logins when you set up a database, plus the Profiler's
> activities.
>
> Yes, I'm taking voer my first SQLServer database and have been asked to
> make sure that this database is closely monitored for inappripriate
> activity.
>
> Questions:
> 1) Does SQLServer have this capability? (Sybase has this, which is
> where I'm coming from)
> 2) Does SQLServer do this automatically or do I have to set up the
> events to be tracked as happens with Sybase?
> 3) What commands are there for setting up these events to be tracked?
>
> Thanks in advance!
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация