Audit Tables info

system · September 24, 2003, 9:58pm

Could some one let me know where can i find the detailed info about audit tables

karen (BOB member since 2003-06-18)

system · September 24, 2003, 10:04pm

Try here , here , here, and the manual for starters. Those threads should yield you some excellent keywords for a BOB search.

Cindy Clayton (BOB member since 2002-06-11)

system · September 24, 2003, 10:16pm

thanks

karen (BOB member since 2003-06-18)

system · September 24, 2003, 10:18pm

Hi i actually need info about each and every audit table.About table description and columns .

karen (BOB member since 2003-06-18)

system · September 24, 2003, 10:35pm

I’d just turn on auditing to the database. That will automatically create the tables for you. Then you can look at them. They are…

OBJ_A_EVENT_LOG
OBJ_A_EVENT_DETL
OBJ_A_APPLICATION
OBJ_A_EVENT_NAME
OBJ_A_OBJECT_TYPE

I may have missed one or two.

Cindy Clayton (BOB member since 2002-06-11)

system · September 24, 2003, 11:23pm

Look in the Webi Administrator PDF. It contains a list of the tables, their purpose, and (in a few cases) some sample contents. Search for one of the table names that Cindy posted and that will get you to the right area.

Dave

Dave Rathbun (BOB member since 2002-06-06)