Skip to Content
0
Former Member
Jan 08, 2015 at 06:16 PM

GRC 10.0 Firefighter Data tables and their Auth Groups

6288 Views

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