OraFAQ Forum: Forms » Tree for the forms

Home » Developer & Programmer » Forms » Tree for the forms (Forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tree for the forms [message #409830]

Wed, 24 June 2009 03:46

samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong

Senior Member

Hi,

I have around 30 forms and reports in my application and i have assigned the rights for the different user. Now i want to create the tree for this as per the rights given to the particular user tree has to be created.

How to do this please help me

Samit Gandhi

Report message to a moderator

Re: Tree for the forms [message #409942 is a reply to message #409830]

Wed, 24 June 2009 09:33

djbabu
Messages: 14
Registered: May 2009

Junior Member

Can I suggest you a different solution for this :

USER_Master --- List all your users here
~~~~~~~~~~~~
User_id
Role_id
User_name
password_name
First_name
Last_name

Role_Master --- Create Roles List Manager, Finance, Accounts, End user..
~~~~~~~~~~~
Role_ID
Role_name

Form_Master --- List all your 20 forms here..
~~~~~~~~~~~
Form_ID
Form_Name

Role_Form --- Specify the Role Form Mapping...
~~~~~~~~~~~
Role_ID
Form_ID

Steps :
(0) Create & Populate the above 4 tables appropriately.
(1) Create a form to authenticate the user by {User_name/password_name}..
(2) Display the available forms for the user and to access it.

Report message to a moderator

Re: Tree for the forms [message #409946 is a reply to message #409830]

Wed, 24 June 2009 09:37

djbabu
Messages: 14
Registered: May 2009

Junior Member

Please update the following, I thought its just 20 forms..

Instead of this :

Form_Master --- List all your 20 forms here..
~~~~~~~~~~~
Form_ID
Form_Name

Module_Master --- List all your 30 Forms/Reports here..
~~~~~~~~~~~
Module_ID
Module_Name

Role_Module --- Specify the Role Module Mapping ...
~~~~~~~~~~~
Role_ID
Module_ID

Report message to a moderator

Previous Topic:	Migration from Forms 6i to Forms 10g - Data update problem
Next Topic:	Button trigger filling multiple fields in detail-form ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:24:53 CDT 2024