Archives of the TeradataForum

Message Posted: Thu, 06 Sep 2001 @ 17:39:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

We are trying to log activity against the logonrule table... as part of testing I think I am asking it to log selects... it does not appear to work... did I miss something......????

begin logging with text on each select on table dbc.logonruletbl;

begin logging with text on each select on table dbc.logonruletbl;

*** Begin logging completed. *** Total elapsed time was 1 second.

 BTEQ -- Enter your DBC/SQL request or BTEQ command:
select * from dbc.logonruletbl;

select * from dbc.logonruletbl;

 *** Query completed. 11 rows found. 8 columns returned.
 *** Total elapsed time was 1 second.

UserID   LogicalHostID LogonStatus NullPassword CreateUID     CreateTimeSta
-------- ------------- ----------- ------------ --------- -----------------
0000EB03          1015 G           T            ?                         ?
00000200          1022 G           T            00000100    2001-09-04 09:3
00000200          1024 G           F            ?                         ?
00000200          1014 G           T            ?                         ?
00000200           100 G           F            ?                         ?
00008C0B          1024 G           T            ?                         ?
00000200          1015 G           T            ?                         ?
00000200           101 G           T            ?                         ?
0000F821             0 G           T            ?                         ?
00007E14          1015 G           T            ?                         ?
00004A1E             0 G           T            ?                         ?

 BTEQ -- Enter your DBC/SQL request or BTEQ command:
select * from dbc.acclogtbl;

select * from dbc.acclogtbl;

 *** Query completed. No rows found.
 *** Total elapsed time was 1 second.

Christopher Platt
Teradata Systems Administration

	<Prev	Next>		<<First	<Prev	Next>	Last>>