A script-enabled browser is required for this page to function properly.

About Database Roles

Oracle Forms enforces menu security on the basis of database roles--Lists of users that, because of their job responsibilities, have similar requirements for access to information. For example, you might create roles named Managers and Clerks.

You create roles once, and then use them to provide:

Once you create a role, you can assign that role to individual menu items. When you limit menu item access to to certain roles, only end users who have been granted that role can select the menu item at runtime.

Menu security based on database roles is independent of a particular menu module. In other words, once a role has been defined, developers subsequently can grant that role access to any menu module or menu item.

Note: To enforce menu security features, the application must be connected to the database at runtime, since Oracle Forms interrogates the database at startup to determine the roles to which the current end user belongs.


About creating and granting database roles

About manipulating database roles at runtime