GRC Important Tables

Table	Table Description	Long Description
GRACREQ	Request Header	This table will provide the information about Request ID, Request Type, Request Creation Date and Request Priority
GRACREQUSER	User Associated with Request	This table will provide the information about user for whom GRC request has been raised and provides details about User ID, User First Name, User Last Name and User Email ID
GRACREQPROVITEM	Line Items Associated with Request	This table will provide the information about the request and the below Line Items in the request with their corresponding VALID FROM and VALID TO dates.
GRACREQPROVLOG	Request Provsioning Log	This table will provide the information about the request and the Line Items in the request with their provisioning status (Success or Failure or Warning)
GRFNMWRTINST	MSMP Runtime - Instance Header Info	This table will provide the information about the request and its corresponding instance status.
GRFNMWRTAPPR	MSMP Runtime - Current Approvers for Line	This table will provide the information about the request and current approvers for corresponding Line Items in the request.
GRACROLE	Role	These tables will provide the information about the roles and their corresponding role owners maintained in BRM.
GRACROLEAPPRVR	Role Approver

SAP Security Tables	SAP Security Tables
AGR_1016	Name of the activity group profile
AGR_1016B	Name of the activity group profile
AGR_1250	Authorization data for the activity group
AGR_1251	Authorization data for the activity group
AGR_1252	Organizational elements for authorizations
AGR_1253	Authorization Data for Activity Group - St
AGR_AGRS	Roles in Composite Roles
AGR_AGRS2	Role definition
AGR_ATTS	Role attributes
AGR_BUFFI	Internet Links for a Role
AGR_BUFFI2	Internet links table - Customer version of
AGR_BUFFI3	Internet links table - SAP versions of SAP
AGR_CUSTOM	Role Customizing objects
AGR_DATEU	Personal settings for roles
AGR_DEFINE	Role definition
AGR_FAVOS	Personal settings for PFCG
AGR_FLAGS	Role attributes
AGR_FLAGSB	Role attributes
AGR_HIER	Table for Structure Information for Menu
AGR_HIER_BOR	Table for Object-Oriented Navigation (OBN)
AGR_HIER2	Menu structure information - Customer vers
AGR_HIER3	Menu structure information - SAP version o
AGR_HIERT	Role menu texts
AGR_HIERT2	Role menu texts - Customer version of SAP
AGR_HIERT3	Role menu texts - SAP Original
AGR_HPAGE	Role Home Page
AGR_HPAGET	Description of the Home Page for a Role
AGR_INFO	Filter Values from Generation Run
AGR_LOGSYS	Logical system
AGR_LSD	Role attributes
AGR_MAP_KNUMA	Conversion Table AG_GUID CRM <> KNUMA
AGR_MAPP	MiniApps in Role
AGR_MARK	Table for report SAPPROFC_NEW
AGR_MEM_INITIAL	Agreements: Buffer for Intial Upload
AGR_MINI	MiniApps in Role
AGR_MINI2	MiniApps in Role
AGR_MINIT	Role mini-appl texts
AGR_MINIT2	Role mini-application texts
AGR_NUM_2	Internal Counter for Assigning Profile Nam
AGR_NUMBER	Internal Counter for Assigning Profile Nam
AGR_OBJ	Assignment of Menu Nodes to Role
AGR_PROF	Profile name for role
AGR_REL_KNUMA_CM	Assignment: Agreement   > Campaign
AGR_SELECT	Assignment of roles to Tcodes
AGR_TCDTXT	Assignment of roles to Tcodes
AGR_TCODE3	Assignment of roles to Tcodes
AGR_TCODES	Assignment of roles to Tcodes
AGR_TEXTS	File Structure for Hierarchical Menu - Cus
AGR_TIME	Time Stamp for Role (Menu, Profile, Author
AGR_TIMEB	Time Stamp for Role (Profile Generation)
AGR_TIMEC	Time Stamp for Role (User Assignment)
AGR_TIMED	Time Stamp for Role (Profile Comparison, R
AGR_USERS	Assignment of roles to users
AGR_USERT	Assignment of roles to users

SAP GRC AC

Name of the Program	Description	INCREMENTAL
		Frequency	Start Time
GRAC_PFCG_AUTHORIZATION_SYNC	Authorization Sync	N/A
GRAC_REPOSITORY_OBJECT_SYNC	User, Role and Profile Sync	every 6hrs	5:00AM
GRAC_ACTION_USAGE_SYNC	Action Usage Sync	N/A
GRAC_ROLE_USAGE_SYNC	Role Usage	N/A
GRAC_SPM_LOG_SYNC	SPM Workflow Log Sync	N/A
GRAC_BATCH_RISK_ANALYSIS	Risk Analysis in Batch Mode	Daily	5:00AM
GRFNMW_BATCH_EMAIL_REMINDER	Email Reminder	N/A

Name of the Program	Description	FULL
		Frequency	Start Time
GRAC_PFCG_AUTHORIZATION_SYNC	Authorization Sync	N/A
GRAC_REPOSITORY_OBJECT_SYNC	User, Role and Profile Sync	Weekly	5:00AM
GRAC_ACTION_USAGE_SYNC	Action Usage Sync	N/A
GRAC_ROLE_USAGE_SYNC	Role Usage	N/A
GRAC_SPM_LOG_SYNC	SPM Workflow Log Sync	N/A
GRAC_BATCH_RISK_ANALYSIS	Risk Analysis in Batch Mode	Weekly	5:00AM
GRFNMW_BATCH_EMAIL_REMINDER	Email Reminder	N/A

Name of the Program	Description	NORMAL
		Frequency	Start Time
GRAC_PFCG_AUTHORIZATION_SYNC	Authorization Sync	every 6hrs	5:00AM
GRAC_REPOSITORY_OBJECT_SYNC	User, Role and Profile Sync	N/A
GRAC_ACTION_USAGE_SYNC	Action Usage Sync	every 6hrs	5:00AM
GRAC_ROLE_USAGE_SYNC	Role Usage	every 6hrs	5:00AM
GRAC_SPM_LOG_SYNC	SPM Workflow Log Sync	Daily	5:00AM
GRAC_BATCH_RISK_ANALYSIS	Risk Analysis in Batch Mode	N/A
GRFNMW_BATCH_EMAIL_REMINDER	Email Reminder	Daily	7:00AM

SAP GRC AC Jobs

SAP SBWP

RSSODLIN - flags all SBWP inbox documents of a certain user for reorganization (completely clears the slected folder)  - note 63912.

RSSOINBD - flags all SBWP inbox documents of a certain user for reorganization - note 640160.

RSSODLWF - flags all send notifications for organization - note 131031.

RSSOREDF - flags all documents referenced to a batch user for reorganization - note 516110.

RSSOMOVE - with this report you may flag contents of a user's inbox for reorganization, while filtering the data by date (This is the most useful, though unread or unexpired documents will not be deleted).

SAP SM19 add Filter

update the following parameter and restart sap.

rsau/selection_slots




SM19 Configuration Parameters

rsau/enable: Set to 1 to activates audit logging
rsau/local/file: Name and location of the audit log file
rsau/max_diskspace/local: Max. space of the audit file. If maximum size is reached auditing stops.
rsau/selection_slots: Max. number of filters


The settings are activated after the instance has been restarted.

How to check EHP Level in SAP.

1.        For Netweaver EHP

Check for  SAP_BASIS or  SAP_ABA eg : 701 which means Netweaver 7 and Ehp 1

2.        For ERP EHP

Check for SAP_APPL  604  which means  Ehp 4 for ERP 6

Export Putty Sessions

Click on Start -> Run -> and enter the following regedit command in the run dialog box,


regedit /e "%userprofile%\desktop\putty-sessions.reg" HKEY_CURRENT_USER\Software\Simontatham

File will be created in the desktop of your 

system. copy the file in the target system and double click on the registry file and accept to add to your registry.You will find all the session in your putty.