Using APEX Authorisation Schemes In PLSQL PDF Print E-mail
Friday, 20 November 2009 23:46

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

 
| More

Sponsored Links

Who's Online

We have 14 guests online