Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


1
(click on this box to dismiss)

User Monitoring

How can I monitor the users' login to the database? I would like to track automatically, into a file, their activity.

link comment (0)
asked 3 years ago
cubriduser
35
6 Answers
0

This is already done by CUBRID Broker. There are three different logs you can find in the $CUBRID/log/broker/ directory:

  • Access logs: lists CAS ID, user IP, start time, end time, the time elapsed, process id, and info. Info column includes database name as well as database user name which accesses this database.
  • Error Logs: various error logs are written into these files.
  • SQL logs: all incoming logs are written in these files. Additionally slow queries are also logged for further examinations.

You can refer to these files to see which user has logged into which database at what time as well as what query they have executed.

Also, if you want to monitor users who access your database using CUBRID Manager, you can refer to logs located in $CUBRID/log/manager/. You can look into cub_js.access.log file to see what commands your database users have tried to execute using CUBRID Manager.

All these user activity logs can also be viewed directly in CUBRID Manager under Logs in the Hosts panel on the left.

link comment (0)
answered 2 years ago
dba
558
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: