Security and Memory Resident Tables

The following security-related tables are part of the MRT file. To bypass running the MRT Generation process and bouncing of the application for any of these tables, add the Database Name to the BypassMRTLookupList parameter in the ADV30Params.ini file. The application must be bounced for the changes to take effect.

Data Structure

Database Name

Application Resource QueryObject

R_SC_APPL_RSRC_QRY

Access Control (SCRACS)

R_SC_RSRC_ACCS

Security QueryObject used internally, required

q_CombOrgCode

Secured Field Resources (SCFUSE)

R_SC_RSRC_FLD

Field Access (SCFACS)

R_SC_FLD_ACCS

Field Comparison

R_SC_FLD_CMPR

User Interface Field Security (SCUIFS)

R_SC_UI_FLD_SEC

Foreign Organization (SCFORG)

R_SC_FGN_ORG

The following security-related tables are not part of the MRT file:

Data Structure

Database Name

User Information (SCUSER) table

R_SC_USER_INFO

User Directory Information

R_SC_USER_DIR_INFO

Assign Security Role to User (SCUROL) table

R_SC_USER_ROLE_LNK

Security Role (SCROLE) table

R_SC_ROLE