Friday 27 January 2012

How to know who all accessed a database object?

We could use the DBC view DBC.ACCESSLOG.
This view would contain the information about who all accessed the database object.

Other way to find this out is the query logging (DBQL).
All the view under DBC database that start with DBQL* are tables that contain logging information.
However data that gets stored in this tables is controlled by the rules that are set up by the admin.
These rules can be viewed inside the table DBC.DBQLRules.


No comments:

Post a Comment