On 7/20/2017 11:11 PM, Nikhil wrote:
> Schema = tenant. So basically tenant level logging.
select .... from schema1.table1 join schema2.table2 on .... where
.....;
if you have per schema logging, where should that get logged ?
you could implement per DATABASE logging, if you A) add the database
name to the log_prefix, and B) feed your logs to a program that
understands this and splits them out to a log file per database. you
could also do this on a per user basis. but, schema is something very
dynamic, its a namespace within a database, and queries can touch
multiiple schemas.
--
john r pierce, recycling bits in santa cruz