Re: FORMS: Menu Security

BAMAN MOTIVALA <bmotivala_at_swipnet.se> wrote in article <kvRp3.1401$i%3.2211_at_nntpserver.swip.net>...
> Hello,
>
> In order to implement Menu Security do the Forms User Views have to be
> installed along with the application schema?
Yes. But you can also use Roles to display or hide menu items if you wish.

>If so does every application
> user have to be granted access to these views?
When you run Developer 2000 ---> Admin --> Build as SYSTEM It creates the appropriate tables and IMO, grants SELECT access to public.

then you run Developer 2000 --> Admin -->grant to give insert privileges to developers only. You need to specify Developers usert_ids separated by commas as you run this script.

The SQLs are
 in orant\tools\dbtab20\forms50 and orant\tools\db\forms50 for Release 5.0. in my release it was
missing whole bunch of table creation scripts.

I have chosen to use the Database Roles to give access to Applications to users rather than the
Menu Roles. I check whether the user has a role to access an application in when-new-form-instance
of the form to which the menu is attached and display or hide the application option. Unless you want to control access to users at nested menu item levels, this works fine and is less work.

If you want the PL/SQL proc for this let me know.

Suresh Bhat
Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com  

> Thanks
>
> Baman
>
>
>
Received on Wed Aug 04 1999 - 16:46:40 CEST