Re: Schemas & Forms applications

You need to create a public synonym for your table create public synonym tablename for research.tablename Then all users will see the table, assuming you give them all privileges to access it.

Fraser

Kevin Hughes wrote:

> 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