it does not matter what kind of users usually each application has it's own datanase and it's own user, the application makes the connection and can at this point log whatever you want
using the "general query log" can only be a bad joke you will log EVERY query and not only logins again: it is not the job of a RDBMS to waste I/O and performance with such things - the application as example could refresh it only once per user-session the RDBMS would write blindly for each connection Am 04.10.2012 18:18, schrieb Aastha: > Yes, i meant DB users. > > On Thu, Oct 4, 2012 at 10:57 AM, Johan De Meersman <vegiv...@tuxera.be > <mailto:vegiv...@tuxera.be>> wrote: > > > ----- Original Message ----- > > From: "Reindl Harald" <h.rei...@thelounge.net > <mailto:h.rei...@thelounge.net>> > > > > this makes pretty no sense and is NOT the job of a RDBMS > > implement it in your application / db-abstraction-layer > > I notice no specification of what kind of users, so I'm assuming DB > users. There *is* such a thing: you can > find it in the general query log. Turning that on is a considerable > performance overhead, though, and so is > firmly discouraged on production systems.
signature.asc
Description: OpenPGP digital signature
