Oracle Menu Permissions data model and PL/SQL framework has six tables and two packages.

Tables

• menu items table that stores the menu in the application
• menu roles table that stores the permissions on menu items for each role
• menu users table that stores the special permissions on menu items for each user
• users table that stores the users in the application
• roles table that stores the roles in the application
• users roles table that stores the roles for each user.

Packages

• users management package that contains the procedures that add roles, add users and set roles to users
• menu management package that contains the procedures and functions that add menu items, set permissions on the menu items and return the permissions on menu items.

You can download and run the objects.sql script that creates all the objects contained by the framework.