This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JDBC and the fly likes monitoring querys Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "monitoring querys" Watch "monitoring querys" New topic
Author

monitoring querys

Luis Fernandes
Greenhorn

Joined: Sep 22, 2007
Posts: 19
Hello,

Its possible to know if someone is try to gain acces to my database ?

I want to monitoring my database ( in sql server 2000 ) named PRODUTION.

I whant a report or alert allways some service or app make a sql select against to my database . and this report must show me the user and the table that are afect

Its possible to do that ?

Regards


Luis Claudio<br />MCSE ; CCNA ; SCJP 5.0
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3697
    
    5

It's possible within the database management software (log files) but not within JDBC.


My Blog: Down Home Country Coding with Scott Selikoff
 
wood burning stoves
 
subject: monitoring querys
 
Similar Threads
how to display Access Reports.
getting database stats using jdbc (oracle)
Design help for the Data Loaders
Errors running 2.1.6 under Oracle 9.2.0.6 / WebLogic 8.1 SP5
Transfer Excel Sheet information to database