MS SQL Server - SQL Security Logging

Author

SQL Security Logging

Jason Carter

2005-08-10, 8:23 pm

Does anyone know of any built-in functionality or third party utility that
can log who accesses a SQL database? We have several developers that all MUST
use the SA username and password to access the databases and all from a
Citrix session. I need to know when a connection is made to the database the
username of the Citrix session at the time SA connected to the database.

Anyone know of anything that can do that?

mikeb

2005-08-10, 8:23 pm

Have you looked at SQL Profiler to trace transactions - filtering by the
values you need?

-Mike

"Jason Carter" < JasonCarter@discussi
ons.microsoft.com> wrote in message
news:566C4C2B-803E-4C9B-BA3B- E00E52A4A5EE@microso
ft.com...
> Does anyone know of any built-in functionality or third party utility that
> can log who accesses a SQL database? We have several developers that all
> MUST
> use the SA username and password to access the databases and all from a
> Citrix session. I need to know when a connection is made to the database
> the
> username of the Citrix session at the time SA connected to the database.
>
> Anyone know of anything that can do that?

Wayne Snyder

2005-08-11, 8:23 pm

Probably not, since all of the connections are coming from a single Citrix
server.

--
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

"Jason Carter" < JasonCarter@discussi
ons.microsoft.com> wrote in message
news:566C4C2B-803E-4C9B-BA3B- E00E52A4A5EE@microso
ft.com...
> Does anyone know of any built-in functionality or third party utility that
> can log who accesses a SQL database? We have several developers that all
> MUST
> use the SA username and password to access the databases and all from a
> Citrix session. I need to know when a connection is made to the database
> the
> username of the Citrix session at the time SA connected to the database.
>
> Anyone know of anything that can do that?

Sponsored Links