[dba-SQLServer] Who's using my db?

Hello Christopher,

My guess is that unless MS provide this to you, you have no chance to
program it.

There are so many ways to even connect to SQL, ADO, ODBC, DTS, etc,
that you would find it difficult to code it yourself, but aside from
that, I have never heard of any type of events that fire when you open
a table, or move to a new record etc.  So, unless MS log all this (and
it would surely be a hugh log file), I fear that it may not be
possible.

But again, it would be facinating to see if such a feature is available.

Mark



On Wed, 8 Dec 2004 14:50:37 -0700, Mackin, Christopher
<CMackin at quiznos.com> wrote:
> If I could somehow grab either the computer name or windows login name then I'd fine, waht is eluding me is how to trigger an event when a connection to the server or database is created, or even if that information is already stored somewhere.
> 
> Mark, I will let you know if I come up with a viable solution to this.
> 
> 
> 
> -Chris Mackin
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Mark
> Breen
> Sent: Wednesday, December 08, 2004 12:37 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Who's using my db?
> 
> Hello Christopher,
> 
> I am very interested in this one also,
> 
> Charlotte, I think that this is a regular situation, dba's are
> responsible for a payroll database that I know of, but they really
> should not be in the tables looking at data.
> 
> Christopher, I have no answer for you, but I would love to see what
> you come up with.  it strikes me that OS security may be a starting
> point 'cause with sa, we really do not know who it is.
> 
> Cheers
> 
> Mark in wet but not freezing cold Ireland.
> ( I am just back from a weeking in Belgium, boy is it cold over there,
> it gets down to close to freezing at night)  I had to wear a coat and
> a hat at times.
> 
> On Tue, 7 Dec 2004 14:36:35 -0700, Mackin, Christopher
> <cmackin at quiznos.com> wrote:
> > Um...Yes.
> >
> > The server is owned by one company and the IT infrastructure is maintained by the parent company, the parent company's IT staff has full rights to everything on the server in order to maintain the system as a whole but is not allowed to be looking at the data in specific db's.
> >
> > -Chris Mackin
> >
> >
> >
> >
> > -----Original Message-----
> > From: dba-sqlserver-bounces at databaseadvisors.com
> > [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
> > Charlotte Foust
> > Sent: Tuesday, December 07, 2004 2:25 PM
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: RE: [dba-SQLServer] Who's using my db?
> >
> > Um ... You have dbas that can't look at the data??
> >
> > Charlotte Foust
> >
> > -----Original Message-----
> > From: Mackin, Christopher [mailto:CMackin at quiznos.com]
> > Sent: Tuesday, December 07, 2004 10:57 AM
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: [dba-SQLServer] Who's using my db?
> >
> > Does anyone have any suggestions on how to track/view a log of users
> > that have accessed information on the Server and specifically at the
> > Database level?
> >
> > There are users authorized to view a particular db with confidential
> > information, and I need to verify that no other users are accessing this
> > data.  In this situation it's rather complex because security keeps out
> > the majority of people, but there are certain people with the sa
> > password and admin rights on the server that should not be looking
> > either.
> >
> > Thanks in advance,
> > Chris Mackin
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> _______________________________________________
> 
> 
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>