GRC Tables-Access Controls

Find the list of tables for GRC Access Controls

Table Name	Short Description
GRACACFIELD	AC Fields
GRACACFIELDT	Text table AC fields
GRACACTION	Action Table
GRACACTIONSYST	Action Connector Text Table
GRACACTIONT	Action Text Table
GRACACTIONTYPE	Action Type
GRACACTIONTYPET	Text table for Action Type
GRACACTPERM	Action Permission relation
GRACACTPERMSYS	Connector Specific Action Permission Relations
GRACACTRULE	SOD Action Rule Detail
GRACACTRULEEXT	SOD Action Rule Detail  For Extended Objects
GRACACTRULHDR	Action Rule Header
GRACACTUSAGE	Aktionsverwendung
GRACACTUSAGE	Action Usage
GRACALACTLOG	Alerts Action Log
GRACALDETAILS	Alerts detailed Info
GRACALHDR	Alerts Header Info
GRACANALYZEDOBJ	Analyzed Objects
GRACAPPLMAPPING	Application function mapping
GRACAPPLTYPE	Application type
GRACAPPLTYPET	Application type
GRACATTRSCOPE	Attribute Scope
GRACAUDITLOG	Security Audit Log table
GRACAUTHPERM	Object Permission Table
GRACAUTHPERMT	Authorization Permission Text Table
GRACAUTHPMSYST	Authorization Permission Connector Text Table
GRACBGNAMEVALUE	Name Value pairs for Background Parameter Value
GRACBGPERMISSION	Name Value Pairs for Background Job Permission Parameter
GRACBGRANGE	Range table values for Background Job variant
GRACBGRULEGEN	Background Rule Generation.
GRACBGTECHROLE	Stores values for Background Job Parameter Value
GRACBPROC	Business Process
GRACBPROCAA	Business Process and Application Area Link
GRACBPROCT	Business Process Text
GRACBSUBPROC	Business Subprocess
GRACBSUBPROCT	Business  Subprocess
GRACBUSROLEPROV	Table to store busniess role provisioning information
GRACBUSROLESNAP	Business Role Snapshot
GRACBUSROLEUSERS	Business Role User Reassignment
GRACCFFCTRLT	Text table for GRACFFCTRL table
GRACCHANGELOG	Data Change Log table
GRACCLASS	Authorization Class Table
GRACCLASSSYST	Authorization Class Connector Text Table
GRACCLASST	Authorization Class Text Table
GRACCLMQUERY	CLM query mapping
GRACCNDGPAPV	Condition Group and Approver Relation
GRACCNDGPMTH	Condition Group Methodology Relation
GRACCNDGPTPBRF	Condition group type to BRF+ function assignment
GRACCNDGPTYPE	GRC ERM Condition Group Type
GRACCNDGPTYPEBRF	Condition group type to BRF+ function assignment.
GRACCNDGPTYPET	GRC ERM Condition Group Type Text
GRACCOMPANY	Company
GRACCOMPANYT	Company text
GRACCONACT	Connector Action
GRACCONACTT	Connector Action Text
GRACCONATTR	Connector Attribute
GRACCONATTRIDM	Connector attributes for IDM
GRACCONATTRLDP	Connector attributes for LDAP
GRACCONATTRSAP	Connector attributes for SAP
GRACCONATTRWS	Connector attributes for WS
GRACCONFIG	Configuration Parameter Table
GRACCONFIGSET	Configuration Description
GRACCONFIGT	Configuration Text Table
GRACCONGRPSTAT	Connector Group Status
GRACCONNSTAT	GRC Connector Status
GRACCRITICLTY	Criticality Levels
GRACCRITICLTYT	Text table for Criticality levels
GRACCRITILVL	Critical Level
GRACCRITILVLT	Critical Level Text
GRACCRPROFILE	Critical Profile Rule
GRACCRPROFILET	Text Table for Critical Profile
GRACCRROLE	Critical Role Rule
GRACCRROLET	Text table for Critical Role
GRACCTGRP	Master table for SPM Controller Groups
GRACCTGRPDTL	Maintain Controllers assigned to Controller Groups
GRACCTGRPDTLT	Text Table for GRACCTGRPDTL table
GRACCUADIST	CUA-Distribution Model
GRACCUAMSTR	CUA-Master table
GRACCUSTGRP	Custom group table
GRACCUSTGRPT	Custom group  text table
GRACDETDESCT	Detail Description Text Table
GRACEMPTYPE	Employee Type
GRACEMPTYPET	Text table for Employee Type
GRACERMARC	Archiving table for role data
GRACERMAUDITLOG	Audit log Changes
GRACEUP	End User Personalization
GRACEUPCONFIG	End User Personalization Fields
GRACEUPCONFIGID	Configuration Field ID
GRACEUPCONFIGT	Description for EUP fields
GRACEUPCRIT	End User Personalization Criteria
GRACEUPT	End User Personalization Description
GRACEXCLUDEDOBJS	AC batch Risk Analysis Excluded objects.
GRACEXTOBJ	Table for extended length objects
GRACEXTRISK	External Risk
GRACFFCTRL	Maintain assignment of FF ID or Role to Controllers
GRACFFCTRLGRP	Maintain Controller Group and FF ID/Role Assignment
GRACFFCTRLGRPT	Text Table for GRACFFCTRLGRP table
GRACFFLOG	Details related to Firefighter ID Log On Information
GRACFFOBJECT	Maintain SPM Firefighter ID and Role details
GRACFFOBJECTT	Text table for Firefighter ID and Role details
GRACFFOWNER	Master table for Fire fighter Owners and FF ID/Roles
GRACFFOWNERT	Fire fighter Owners
GRACFFREPMAPP	FFLOG and Repository Mapping for Firefighters
GRACFFUSER	Maintain SPM Firefighter Assignment to FF ID/Roles
GRACFFUSERT	Details related to FF ID or role assignment to Firefighter
GRACFLD	Table for Field Name
GRACFLDMAP	Group Field Mapping
GRACFLDSYS	Connector Specific Field Name
GRACFLDSYST	Table for System and Field
GRACFLDT	Text Table for Field table
GRACFLDVAL	Table for Field value
GRACFLDVALSYS	Connector Specific Field values
GRACFLDVALT	Text Table Field Value
GRACFUNC	Function
GRACFUNCACT	Function Action Relationship
GRACFUNCACTEXARC	Function Action Relationship For Extended Objects
GRACFUNCACTEXT	Function Action Relationship For Extended Objects
GRACFUNCPRM	Function Action Permission relationship
GRACFUNCPRMARC	Function Action Permission Archive
GRACFUNCPRMEXARC	Function Action Permission relationship for Ext Objs-Archive
GRACFUNCPRMEXT	Function Action Permission relationship for Extended Objects
GRACFUNCPRMEXTN	Function Action Permission Extension
GRACFUNCPRMEXTNE	Function Action Permission Extension for Extended Objects
GRACFUNCT	Function Description Translations
GRACFUNCTAREA	Functional Area Table
GRACFUNCTAREAT	Functional Area text table
GRACFUNUSAGE	SOD Function Usage
GRACGRCPI	Table to Activate GRCPI
GRACGRPOPRMAP	Group Operation mapping
GRACHRACT	CUP HR Actions
GRACHRACTT	CUP HR Action Description Text Table
GRACHROBJACTVL	HR Object Action Violation Table
GRACHROBJCRPVL	HR Object Critical Role/Profile Violation Table
GRACHROBJPRMVL	User Permission Violation Table
GRACHRSYS	CUP HR System
GRACIDMCUA	IDM CUA parent system
GRACIDMCUADIST	Grac Idm Cua distribution
GRACIDMREQ	Consists of idm requests of batch request
GRACIDMRESP	Response data
GRACIDMSCHEMABUF	Grac : Buffer Schema for connection id
GRACLNGTXT	Language Text
GRACMENUAUTH	Auth mapping table for AC IA.
GRACMGALERTS	Management Alerts
GRACMGMTACTUSAGE	Management Action usage
GRACMGRISKD	Risk Analysis Mgmt Sum data  for Batch Risk Analysis.
GRACMGRULECOUNT	Management Report Rule Count by Period and Connector.
GRACMITMSMPVALI	Mitigation Assignment Workflow Validation
GRACMITOBJECT	Mitigating control assignment
GRACMITPROF	Profile mitigating control assignment
GRACMITROLE	Role mitigating control assignment
GRACMITROLEORG	Role Org mitigating control assignment
GRACMITUSER	User mitigating control assignment
GRACMITUSERGP	User Group mitigating control assignment
GRACMITUSERORG	User Org mitigating control assignment
GRACMTH	GRC Methodology
GRACMTHACTION	GRC ERM Action
GRACMTHACTIONT	GRC ERM Methodology Action Text
GRACMTHSTEP	GRC ERM Methodlogy STep
GRACMTHT	GRC ERM Methodology Text
GRACMWCNFNAPR	MSMP Stage Task Configuration Values for RAR Function WF
GRACMWCNFNAPRV	MSMP Stage Task Configuration Values for RAR Function Workfl
GRACMWCNRKMNT	MSMP Stage Task Configuration Values for RAR Risk Maint WF
GRACMWCNRKMNTV	MSMP Stage Task Configuration Values for RAR Risk Maint WF
GRACMWCNRKRVW	MSMP Stage Task Configuration Values for SOD Risk Review
GRACMWCNRKRVWV	MSMP Stage Task Configuration Values for SOD Risk Review
GRACMWCNSACRQ	MSMP Stage Task Configuration Values for Access Request
GRACMWCNSACRQV	MSMP Stage Task Configuration Values for Access Request
GRACMWCNSAURW	MSMP Stage Task Configuration Values for SPM
GRACMWCNSAURWV	MSMP Stage Task Configuration Values for SPM
GRACMWCNSMITCC	MSMP Stage Task Configuration Values for Mitigation Control
GRACMWCNSMITCCV	MSMP Stage Task Configuraiton Values for Mitigation Control
GRACMWCNSRLAP	MSMP Stage Task Configuration Values for Role Approval
GRACMWCNSRLAPV	MSMP Stage Task Configuration Values for Role Approval
GRACMWCNSUAR	MSMP Stage Task Configuration Values for Access Request
GRACMWCNSUARV	MSMP Stage Task Configuration Values for Access Request
GRACNAMECONPOS	Naming Convention Position Table
GRACNAMECONV	Naming Convention Table
GRACNAMECONVT	Naming Convention text table
GRACNONGRCPI	Globally activate Non-GRC PI
GRACNONGRCPIMAP	Activate Non-GRC PI
GRACNOTIFYMSG	Table for Email notification
GRACNUMRANGE	Number Range for Compliant User Provisioning requests
GRACOBJECTAUTH	contains object(user/role/profile) auth for legacy system
GRACORGLVLMPDL	Tbale for Detailed Org Value Mapping
GRACORGLVLMPNG	Table for Org Value mapping
GRACORGLVLMPT	Org value Mapping Text Table
GRACORGRULE	Organization Rules
GRACORGRULEARC	Organization Rules-Archive
GRACORGRULEHDR	Organization Rule Header
GRACORGRULET	Organization Rules text table
GRACOSCMDLOG	Operating System Command Log table
GRACOWNER	Master table for Central Owner Administration
GRACOWNERT	Owners Text
GRACPARAMDETAIL	Table to get the details of Paramater id
GRACPDPROFILES	PD profile details
GRACPDPROFILET	Table to store descriptions of pdprofile
GRACPERMCLS	Permission Class Relation
GRACPERMCLSSYS	Connector Specific Permission Class Relation
GRACPERMFLD	Permission Field
GRACPERMFLDSYS	Connector Specific Permission Fields
GRACPERMFLDVAL	su24 Permission field value
GRACPERMFLDVALG	Permission field value
GRACPPDATA	Risk Analysis PPF Runtime Package Data.
GRACPPFILTERRNG	Global Application Parameter for Risk Analysis PPF.
GRACPPJOBS	Batch Processing Jobs.
GRACPPOBJATT	Global Application Parameter for Risk Analysis PPF.
GRACPPOBJDATA	Risk Analysis PPF Runtime Package Data.
GRACPPOBJRNG	Global Application Parameter for Risk Analysis PPF.
GRACPPPARAM	Global Application Parameter for Risk Analysis PPF.
GRACPPRSRNG	Global Application Parameter for Risk Analysis PPF.
GRACPPSYSRNG	Global Application Parameter for Risk Analysis PPF.
GRACPREREQ	Prerequisite
GRACPREREQT	Prerequisite Description
GRACPRERQTYP	Role Pre-requisite Type
GRACPRERQTYPT	Prerequisite Type Texts
GRACPRIORITY	Priority
GRACPRIORITYT	Priority Description
GRACPROFACTVLEXT	Profile Action Violations for Extended Objects
GRACPROFILE	Profile
GRACPROFILEACTVL	Profile Action Violation Table
GRACPROFILECRPVL	Profile Critical Role/Profile Violation Table
GRACPROFILEPRMVL	Profile Permission Violation Table
GRACPROFILESYST	Obselete -Table to store descriptions of profile per system.
GRACPROFILET	Table to store descriptions of profile per system Type.
GRACPROFMGMTSUM	Profile Management Total
GRACPROFMGRLCOUN	Management Violated Profile Data
GRACPROFMGVCOUNT	Profile Level Management  Violation Data
GRACPROFPRMVLEXT	Profile Permission Violations for Extended Objects
GRACPROJREL	Project Release Table
GRACPROJRELT	Project Release Text Table
GRACPROVCONFIG	Provisioning configuration
GRACPSSGLOBAL	PSS Global Values
GRACPSSHR	PSS HR Verification
GRACPSSHRT	PSS HR Verification Texts
GRACQUESTION	Group of Questions  for Challenge Response
GRACQUESTIONT	Question Texts  for Challenge Response
GRACREASONCOD	Master table for Reason Codes
GRACREASONCODT	Text table for GRACREASONCOD table
GRACREASONSYS	Reason Code and System assignments
GRACREJREASON	Rejection reason table
GRACREJREASONT	Rejection reason text table
GRACREQ	Request Header
GRACREQOMOBJITEM	HR OM Object assigned to request
GRACREQOWNER	Request Owners Details
GRACREQPROVITEM	Line Items Associated with Request
GRACREQPROVLOG	Request Provsioning Log
GRACREQREF	Reference Request Attributes -- Obsolete
GRACREQSYSTEM	Application Associated with Request
GRACREQTEMPLATE	Access request Templates Table
GRACREQTEMPLATET	Access request Templates Text Table
GRACREQTYPACT	Request Type and Action Association
GRACREQTYPE	Request Type
GRACREQTYPET	Request Type Short Description
GRACREQUSER	User Associated with Request
GRACREQUSERADR	User Communication Fields
GRACREQUSERGROUP	Obselete -- User Groups
GRACREQUSERGRP	User Groups
GRACREQUSERPARAM	Obselete -- Request User Parameters
GRACREQUSERPRM	Request User Parameters
GRACREQUSERSYS	Request Licence Data
GRACREQUSRPASS	Request User Password
GRACREVCORDMAP	Reviewer Coordinator Mapping Table
GRACREVITEM	Review Request related items
GRACREVREJUSER	Reject user table for UAR requests
GRACRISKLEVEL	Risk Level
GRACRISKLEVELT	Risk Level Descriptions
GRACRLATT	Table for attributes for Naming Convention
GRACRLCMPLVLT	Comparison Level Text
GRACRLCOMPANY	Role Company
GRACRLCOMPRL	Roles in Composite Roles
GRACRLCONN	Store roles in backend system, incl roles not maint. in ERM
GRACRLCONNSTA	Role generation status
GRACRLCONNSTAT	Table to store descriptions of roles per system Type
GRACRLCONNT	Table to store role description in backend system
GRACRLCONNVAL	Role Connector (system) Validity
GRACRLCONSTAST	Table to store desc of roles per system in diff system
GRACRLCONSTASYST	Table to store descriptions of roles per system.
GRACRLCUARELAT	CUA Role Relationship
GRACRLCUSTPRF	Template role custom profile details
GRACRLMNTN	Role Maintenance
GRACRLMNTNT	Role Maintenance Text
GRACRLNAMEMAXC	Table for max character of Role Name
GRACRLNAMEMAXS	Table for max character of Role Name
GRACRLORGLVMPG	Role - Org Level Mapping Association table
GRACRLPREREQ	Role Prerequisites
GRACRLSENS	Role Sensitivity
GRACRLSENST	Role Sensitivity Text
GRACROLE	Role
GRACROLEACT	Role Action Table
GRACROLEACTVL	Role Action Violation Table
GRACROLEACTVLEXT	Role Action Violations for Extended Objects
GRACROLEAPPRVR	Role Approver
GRACROLEARC	Role Archiving table for deleted roles
GRACROLECMPLVL	Role Comparison Level
GRACROLECRIT	Role with risk violation
GRACROLECRPVL	Role Critical Role/Profile Violation Table
GRACROLEEXPORT	Table for templatory storing the role to be exported
GRACROLEFA	Role Function Area
GRACROLEFFLOG	Details related to Firefighter ID Log On Information
GRACROLEFLDVAL	Role Field Value
GRACROLEFUNC	Role Function
GRACROLEJOB	Role Mangement Job Log
GRACROLEMAP	Role Mapping table
GRACROLEMGMTSUM	Role Management Total
GRACROLEMGRLCOUN	Management Violated Role Data
GRACROLEMGVCOUNT	Role Level Management Violation Count
GRACROLEORG	Role ORG Level
GRACROLEORGFLD	Role Global Org Fields
GRACROLEORGLVL	Derived Role Leading Org Level Information
GRACROLEPERM	Role Permission Table
GRACROLEPERMAUTH	Role Permission Authorization Table
GRACROLEPHASE	Role Valid Phases
GRACROLEPRMVL	Role Permission Violation Table
GRACROLEPRMVLEXT	Role Permission Violation Table
GRACROLEREAFFIRM	Role Reaffirm
GRACROLERELAT	Role Relationship
GRACROLERELATE	Backend Composite to Single Role relation
GRACROLEREQ	Role Request Details
GRACROLESTATUS	Role Status Table
GRACROLESTEP	Role Step
GRACROLESYSACT	Role System Action Table
GRACROLET	Role Descriptions
GRACROLETICKET	Ticket for role
GRACROLETST	Role Testing Header
GRACROLETSTT	Role Testing Text
GRACROLETYPE	Role Type Table
GRACROLETYPEC	Role type table for Customizing
GRACROLETYPESTA	Status for Role Type
GRACROLETYPET	Role Type Text Table
GRACROLEUSAGE	Role Usage
GRACROLSTATUST	Role Status Text table
GRACRRACTIONS	Table for Role Reaffirm Actions
GRACRTROLELOG	Log of user reason for profile gen with conflicts
GRACRULESET	Rule Set
GRACRULESETT	Rule Set Description
GRACSLA	Service level agreement
GRACSLAT	Text Table for CUP SLA
GRACSODREPDATA	SOD Reporting Framework content
GRACSODREPDUMP	SOD Reporting Framework content
GRACSODREPINDEX	SOD Reporting Framework index
GRACSODREPSTATUS	Report status
GRACSODREVIEW	Item Table for  SOD Request
GRACSODRISK	SOD Risk
GRACSODRISKCONN	Risk - Connector Relationship
GRACSODRISKFUNC	SOD Risk Function Relationship
GRACSODRISKOWN	SOD Risk Owner
GRACSODRISKRS	Risk - Rule Set Relationship
GRACSODRISKT	SOD Risk Description
GRACSODUSERROLE	User Roles For SOD Functions
GRACSTDPI	GRC Non-Pfcg Plugins
GRACSTDROLE	Default Role
GRACSTDROLESYS	Default Role - Role and Systems
GRACSTEP	GRC ERM Action Step
GRACSTEPT	GRC ERM Methodology Step Text
GRACSUPPRULE	Supplement Rule Header
GRACSUPPRULEARC	Supplement Rule -Archive
GRACSUPPRULEHDR	Supplement Rule Header
GRACSUPPRULET	Supplement Rule Header
GRACSUPRULEHDARC	Supplement Rule Header-Archive
GRACSYSCONACTN	Connector-Action assignment
GRACSYSROLETYP	Role Type - Connection Type relationship
GRACSYSRULE	System Specific Rule Mapping
GRACSYSRULEOBJ	System Rule Permissions
GRACSYSTEMLOG	System Security Log table
GRACTASKEXECSTMP	Executed background jobs Table
GRACUSER	User Table
GRACUSERACTVL	User Action Violation Table
GRACUSERACTVLEXT	User Action Violations for Extended Objects
GRACUSERASSIGNME	Obselete - User Assignment Table -( To be deleted )
GRACUSERATTEMPT	Number of Attempt
GRACUSERCONN	Table to store connector specific user
GRACUSERCRPVL	User Critical Role/Profile Violation Table
GRACUSERCUSTGRP	Realtion b/w user-id and customer grp
GRACUSERDEFAULT	User default
GRACUSERDEFAULTT	Text tabel for user default
GRACUSERGROUP	User Group Details
GRACUSERMAP	This table holds master user to connector specific user
GRACUSERMGMTSUM	User Management Total
GRACUSERMGRLCOUN	Management Violated User Data
GRACUSERMGVCOUNT	Management User Violation Count
GRACUSERORG	User ORG Level
GRACUSERPRMVL	User Permission Violation Table
GRACUSERPRMVLEXT	User Permission Violations for Extended Objects
GRACUSERPROFILE	User Profile assignment table
GRACUSERROLE	User Role Assignment Table
GRACUSERSOURCE	Table for Data source
GRACUSRATTR	User Attributes
GRACUSRATTRT	Attribute Description
GRACUSRCONNECTOR	User default connector details
GRACUSRPDPROFILE	User PDProfile assignment table
GRACWFWSCUST	Customizing settings for GRC AC Workflow Web Services
GRACXSRULEMAP	X System Rule logical System Mapping