GRC 10.0 Firefighter Data tables and their Auth Groups

[Former Member]

Hi All,

We are currently trying to secure the firefighter tables in our system for Audit and SOX purposes, for this we need the details of all the table in which the firefighter data resides(Owners, Controllers, Users, FF Assignment History).

Based on my GRAC*FF* search I found the below listed tables, would this be all where the firefighter data gets saved when you update the relevant screen in NWBC or am I missing any of the tables?

Table Names	Table Description
GRACCFFCTRLT	Text table for GRACFFCTRL table
GRACFFCTRL	Lock Object for Controller table
GRACFFCTRLGRP	Maintain Controller Group and FF ID/Role Assignment
GRACFFCTRLGRPT	Text Table for GRACFFCTRLGRP table
GRACFFIDROLE	Fire Fighter ID Connector Role Relation
GRACFFLOG	Lock object for GRACFFLOG table
GRACFFOBJECT	Lock Object for GRACFFOBJECT table
GRACFFOBJECTT	Text table for Firefighter ID and Role details
GRACFFOWNER	Lock Object for table GRACFFOWNER table
GRACFFOWNERT	Fire fighter Owners
GRACFFREPMAPP	Lock object for gracffrepmapp table
GRACFFUSER	Maintain SPM Firefighter Assignment to FF ID/Roles
GRACFFUSERT	Details related to FF ID or role assignment to Firefighter
GRACROLEFFLOG	Details related to Firefighter ID Log On Information
GRACV_FFIDROLE	Fire Fighter ID Connector Role Relation

It would be really helpful if any one can provide some documentation on these firefighter tables, listing out their what they are used for and what processes update these tables and what are the default SAP provided Auth groups restricting the access to them.

Thanks

Narsimha

[former_member185447 · Accepted solution]

Hello Narsimha Reddy,

You have provided the tables as well the purpose of those tables in the description.

As far as Auth groups are concerned, you can go to SE54 and find out the same.

I found most of the tables above are part of &NC&.

Regards,

Deepak M

[Former Member]

Hello Narshima,

You can use transaction SE11 to know the details of the fields in the tables which might help in understanding more about tables

TDDAT - you can get the Table Authorization group to which a table belong from this table

Regards