| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRACACTRULE | SOD Action Rule Detail | 2 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
2 | GRACACTRULEEXT | SOD Action Rule Detail For Extended Objects | 2 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
3 | GRACACTRULHDR | Action Rule Header | 2 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
4 | GRACALHDR | Alerts Header Info | 7 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
5 | GRACHROBJACTVL | HR Object Action Violation Table | 6 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
6 | GRACHROBJPRMVL | User Permission Violation Table | 6 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
7 | GRACMGRISKD | Risk Analysis Mgmt Sum data for Batch Risk Analysis. | 8 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
8 | GRACMITMSMPVALI | Mitigation Assignment Workflow Validation | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
9 | GRACMITOBJECT | Mitigating control assignment | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
10 | GRACMITPROF | Profile mitigating control assignment | 4 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
11 | GRACMITROLE | Role mitigating control assignment | 4 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
12 | GRACMITROLEORG | Role Org mitigating control assignment | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
13 | GRACMITUSER | User mitigating control assignment | 4 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
14 | GRACMITUSERAR | User mitigating control assignment for Access Request | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
15 | GRACMITUSERGP | User Group mitigating control assignment | 4 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
16 | GRACMITUSERORG | User Org mitigating control assignment | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
17 | GRACMITUSERORGAR | User Org mitigating control assignment for Access Request | 6 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
18 | GRACMITUSER_AR | Obsolete | 4 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
19 | GRACMITUSRORG_AR | Obsolete | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
20 | GRACORGRULEHDR | Organization Rule Header | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
21 | GRACPROFACTVLEXT | Profile Action Violations for Extended Objects | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
22 | GRACPROFILEACTVL | Profile Action Violation Table | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
23 | GRACPROFILEPRMVL | Profile Permission Violation Table | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
24 | GRACPROFMGVCOUNT | Profile Level Management Violation Data | 4 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
25 | GRACPROFPRMVLEXT | Profile Permission Violations for Extended Objects | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
26 | GRACROLEACTVL | Role Action Violation Table | 6 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
27 | GRACROLEACTVLEXT | Role Action Violations for Extended Objects | 6 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
28 | GRACROLEMGVCOUNT | Role Level Management Violation Count | 4 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
29 | GRACROLEPRMVL | Role Permission Violation Table | 6 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
30 | GRACROLEPRMVLEXT | Role Permission Violation Table | 6 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
31 | GRACSODREVIEW | Item Table for SOD Request | 6 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
32 | GRACSODRISK | SOD Risk | 2 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
33 | GRACSODRISKCONN | Risk - Connector Relationship | 2 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
34 | GRACSODRISKFUNC | SOD Risk Function Relationship | 2 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
35 | GRACSODRISKOWN | SOD Risk Owner | 2 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
36 | GRACSODRISKRS | Risk - Rule Set Relationship | 2 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
37 | GRACSODRISKT | SOD Risk Description | 3 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
38 | GRACSUPPRULEHDR | Supplement Rule Header | 4 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
39 | GRACSUPRULEHDARC | Supplement Rule Header-Archive | 4 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
40 | GRACSYSRULE | System Specific Rule Mapping | 3 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
41 | GRACUSERACTVL | User Action Violation Table | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
42 | GRACUSERACTVLEXT | User Action Violations for Extended Objects | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
43 | GRACUSERMGVCOUNT | Management User Violation Count | 4 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
44 | GRACUSERPRMVL | User Permission Violation Table | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
45 | GRACUSERPRMVLEXT | User Permission Violations for Extended Objects | 5 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
46 | GRACXSRULEMAP | X System Rule logical System Mapping. | 3 | RISKID | Access Risk ID | nvarchar | 8 | 0 | | |
TOPGRC Access Control Plug-In |
47 | /VIRSA/FUNCTRISK | Function and Risk Relation | 3 | RISKID | ID | nvarchar | 4 | 0 | | |
48 | /VIRSA/MGMTCRTR | User based Critical TCode & Role analysis details | 4 | RISKID | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | | |
49 | /VIRSA/MGMTRISKD | User & Role analysis Risk details | 5 | RISKID | ID | nvarchar | 4 | 0 | | |
50 | /VIRSA/MGMTRISKS | User & Role analysis Risks Total by Risk IDs. | 5 | RISKID | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | | |
51 | /VIRSA/RISKOWNER | Risk Owner | 2 | RISKID | ID | nvarchar | 4 | 0 | | |
52 | /VIRSA/RISKS | Risk Definition | 2 | RISKID | ID | nvarchar | 4 | 0 | | |
53 | /VIRSA/RISKST | Risk Definition Text | 2 | RISKID | ID | nvarchar | 4 | 0 | | |
54 | /VIRSA/RSKWKFLOW | Risk Workflow | 2 | RISKID | ID | nvarchar | 4 | 0 | | |
TOPPlant Maintenance |
55 | EAMWS_RESPONSES | Risk Respones for Safety Checklist | 5 | RISKID | Risk ID | nvarchar | 50 | 0 | | |
56 | EAMWS_RISKS | Risks for Safety Checklist | 4 | RISKID | Risk ID | nvarchar | 50 | 0 | | |
57 | EAMWS_SAFETYMEAS | Safety Measures for Safety Checklist | 7 | RISKID | Risk ID | nvarchar | 50 | 0 | | |