O'Reilly logo

Oracle APEX Cookbook - Second Edition by Marcel Van Der Plas, Michel Van Zoest

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating an authorization plug-in

In Version 4.1, the authorization plug-in was introduced. The advantages of plug-ins are mostly reusability and declarative setup. To demonstrate the use of an authorization plug-in, we will create a page and a tab that will only be displayed when the logged user has the correct privilege, that is ADMIN. This privilege is stored in the APP_USERS table. When the user logs in and he or she has no correct privilege (ADMIN), the tab will not be displayed. On top of that, when the user tries to access that page by modifying the URL (with the concerned page number), an error message will be displayed.

Getting ready

Make sure you have access to an existing application and the APP_USERS table and the APP_COUNTRIES table. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required