Using APEX Authorisation Schemes In PLSQL

APEX allows the developer to define multiple authorization schemes for use throughout the application. Unfortunately APEX, by default, only allows the use of these schemes in certain areas. For example to decide whether a user can see a specific page



or whether a specific page item should be displayed



Luckily there is a way to use the authorization in PLSQL, this is done using the following code

v_bool := apex_util.public_check_authorization('AUTHORIZATION_NAME');

The authorization scheme can now be used on its own, or in a combination with other schemes, as well as being part of more complex logic