What DBMS view does Forms use to drive menu security?
The Forms Menu security just selects from the view FRM50_ENABLED_ROLES as defined in the script FRM60SEC.SQL. – So you can look at that view to see how it works. As far as Forms is concerned it just expects that view to return a column called ROLE and another called FLAG – there is nothing to stop you from creating your own view that queries the Role information in the way you want – or for that reason simply uses tables of your own. As long as the view is called the right thing and returns the correct columns you’re fine. As an FYI we don’t use the FLAG column any more so Just return Zero for that in your view.
