Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 29 Oct 2004 @ 14:54:21 GMT


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


Subj:   Re: Interpreting the ACCLOGRULETBL?
 
From:   Dieter Noeth

Andy Carr wrote:

  I just have a query as to where I might find out how to interpret what the characters in the dbc.acclogruletbl mean. When I look at our table some fields have just an 'F' whereas others have 'F +' and some are blank. I have had a look at any douments I can think of but can only find how to modify access rules. Can anyone help? We're on V2R4.1, I don't know if there's a difference in the access logging in V2R5...  


At least in V2R5.1 you'll find that info within the Data Dictionary Manual, Chapter 3: System Views: Usage and Examples, AccLogRules

1 Position 1 (every privilege check) indicates how often to log checks on this privilege when performed against any requests (submitted by a specified user) that attempt to access the specified object. Possible values that could appear in each position are as follows:

- B Both FIRST and LAST occurrences are to be logged.

- E Each occurrence is to be logged.

- F FIRST occurrence is to be logged.

- L LAST occurrence is to be logged.

- blank No logging.


2 Position 2 indicates how often to log checks on this privilege when performed against requests (submitted by a specified user) that are not allowed to access the specified object (that is, check results are Denials).

- B Both FIRST and LAST occurrences are to be logged.

- E Each occurrence is to be logged.

- F FIRST occurrence is to be logged.

- L LAST occurrence is to be logged.

- blank No logging.


3 Position 3 (save text of request) indicates whether to record the text of the requests that cause a check on this privilege.

- - Save text only for Denial entries.

- + Save text for all entries.

- = Save text for all entries (specified in multiple BEGIN LOGGING statements).

- blank No WITH TEXT option specified.


Dieter



     
  <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: 15 Jun 2023