Re: Database ROLES -- Help

Hi,
You're using the database as a source of your forms and menus. This is seldom recommended due to performence but quite a good idea when sharing accross large development projects.

You need to find your developer 2000 administration menu, and select the GRANT items. Granting access to the developer tables is very important if you plan to use these as a source-foundation. You might want to grant access to PUBLIC and not only named users. It makes it just a slight easier to administrate, but then anyone accessing the database can access the Dev/2000 development (their copy of it).

I recommend that you use FILES not the database as source - then you won't have the designer problems.

• Peter H. Larsen

Carlos Humberto Bonilla wrote:

> I am new to developing in DEV 2000. I am trying to implement menu
> security but when I try to run my application using a user other than
> a DBA It tells me that I have no permission to run FROMS menus. ( I
> think the error code is FRM-10256) Back in the help the description
> for this error code tells me that the user is not registered with
> Oracle FORMS and the user does not have SELECT permissions on the
> FROMS BASE TABLES. What are these BASE TABLES..?. How do I register
> users other than DBA's.?Is there anything else that I needed to do
> when I installed DEV 2000..? Muchas gracias!
Received on Fri Oct 31 1997 - 00:00:00 CET