Re: Schemas & Forms applications

The answer to this is twofold
from the user research you need to GRANT necessary select, insert, update, delete priviliges.
secondly, you need to create public synonyms (create public synonym foo for research.foo etc)

Hth,

Sybrand Bakker, Oracle DBA

Kevin Hughes <j.k.hughes_at_bangor.ac.uk> schreef in berichtnieuws 3922AC33.E378B61E_at_bangor.ac.uk...
> Hi, I've just created my first forms 6.0 application and am preparing to
> deploy it. I have one big concern though. The database name is "bangor"
 and
> I created an user "research" who created the tables for my application.
 The
> forms application was then also created by "research". My problem is that
> if I create another database user, say "User1", when user1 logs into the
> database via the application, will the application now find the tables. As
> far as i understand it tables are prefixed with schema names so when
> "User1" logs onto the application the forms will look for tables named
> user1.tablename which of course don't exist.
>
> How can I overcome this? Do I need to edit my forms application so that
 all
> references to tables are in the format "research.tablename"? Do I need to
> create synonyms for the tablenames? Does forms take care of this itself
> when you prepare the application for deployment?
> I'm really confused about this issue and would be grateful for any help.
> We're a new Oracle site and as yet don't have anybody with any oracle
> experience.
>
> Thanks in advance,
>
> --
> J. Kevin Hughes j.k.hughes_at_bangor.ac.uk
> Administrative Computing
> University of Wales - Bangor
> Adeilad Deiniol
> Ffordd Deiniol / Deiniol Road
> Bangor LL57 2UX
> Tel: (01248) 382373 Fax: (01248) 383826
Received on Wed May 17 2000 - 00:00:00 CDT