MattsBits
MattsBits

MattsBits

Read Only Item Based On Authorization Scheme  

by Matt Hawkins, 17/08/2010
Categories : APEX

It's easy to make an item read-only based on a predefined Authorization Scheme.

1 - Edit the item and click on the "Read Only" tab

2 - Select "PL/SQL Function Body Returning a Boolean"

3 - Insert the following PL/SQL code into the condition box :


if APEX_UTIL.PUBLIC_CHECK_AUTHORIZATION('MY_AUTH_SCHEME') then
return false;
else
return true;
end if;


Where "MY_AUTH_SCHEME" is the name of your Authorization Scheme.

apex_read_only_item.png


Authorization (authorisation) schemes can be defined on the "Authorization Schemes" page under "Shared Components".

Author : Matt Hawkins  Last Edit By : Matt Hawkins
PHP Powered  MySQL Powered  Valid XHTML 1.0  Valid CSS  Firefox - Take Back The Web  EUKHost - Recommended Webhosting Solutions

MattHawkins CMS v3.0 - Copyright 2009-2022