Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Begin logging statement question
 
From:   Christopher Platt

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016