Archives of the TeradataForum
Message Posted: Wed, 17 Mar 1999 @ 16:00:39 GMT
Subj: | | Access Logging on Views Required? |
|
From: | | Paul Lowder |
To kick off this wonderful new list, I have a question about accesslogging.
Let's say you have a database of tables, and a database of views on the tables. Access logging is turned on only for the database of
tables like this:
begin logging with text on each select on database DBT;
Run some selects against the views in the "views" database DBV. These are views on the database of tables.
You get rows in the accesslog table showing that there are hits against the views, but no text of the SQL statement - what do you need to
do to see the SQL text?
|