All Forums Database
ramjasmeenakshi 19 posts Joined 04/11
09 Oct 2015
Access logging v/s dbql object table

Hi,
I have read that in access logging you ask the database to log who’s doing what on a given object. The information stored is based on the object not the SQL fired or the user who fired it.So my question is why we do this when we have same info in dbql object table.
 

Meenakshi Swami
Fred 1096 posts Joined 08/04
12 Oct 2015

Access logging is intended for auditing purposes; the access log row must be written before the request can actually be executed. You can choose to log DDL and DCL as well as DML access, and access to macros, functions, and stored procedures. You can also log DENIALS of access.
On the other hand, DBQL is much lower overhead and recommended if there is no audit requirement, e,g. if you want to determine which tables / columns are used most or least.

ramjasmeenakshi 19 posts Joined 04/11
12 Oct 2015

Thanks Fred!!
 

Meenakshi Swami

You must sign in to leave a comment.