Salesforce

What does selecting the "Use Runtime Permissions Checking" database option mean?

« Go Back

Information

 
TitleWhat does selecting the "Use Runtime Permissions Checking" database option mean?
URL NameP125990
Article Number000155716
EnvironmentProduct: OpenEdge
Version: 10.1x, 10.2x, 11.x, 12.x
OS: All supported platforms
Question/Problem Description
What does selecting the "Use Runtime Permissions Checking" database option mean?
How to specify the run-time permissions data security checking?
Does specifying the "Use Runtime Permissions Checking" database option allow a user to compile code against tables for which he has no data access permissions?
Does selecting the "Use Runtime Permissions Checking" database option replace the default compile time data security checking with runtime data security checking?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution

The Database data security checking is always enforced at compile time.  Selecting "Use Runtime Permissions Checking" database option causes the user table and field security permissions to be checked at both compile time as well as run time.  Hence, if the "Use Runtime Permissions Checking" is NOT set, only authorized users can compile source code and the generated r-code may be run by any other user.  On the other hand, if the  "Use Runtime Permissions Checking" IS set, then only authorized users can compile source code and the generated r-code may be run ONLY by authorized users.

Specifying the "Use Runtime Permissions Checking" database option does not replace the compile time data security checking but augments it with  runtime data security checking .  In other words, the user permissions are checked in both compile and runtime.

To specify run-time permissions data security checking:

  1. Access the Data Administration tool if you are using a graphical interface or the Data Dictionary if you are using a character interface.
  2. Choose Admin > Database Options to access the Database Options dialog box appears.
  3. Check the "Use Runtime Permissions Checking" database option mean and click OK.
Workaround
Notes

References to Other Documentation:

OpenEdge Deployment: Managing ABL Applications, "Database table- and field-level security"

OpenEdge Development: Basic Database Tools, "Admin Menu Reference: Database options"

Progress Article:

 Database Security Enforced at Compile Time - Not at Runtime

Keyword Phrase
Last Modified Date11/20/2020 7:36 AM

Powered by