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>>

Attachments

Library

Quick Reference