Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Schemas & Forms applications

Schemas & Forms applications

From: Kevin Hughes <j.k.hughes_at_bangor.ac.uk>
Date: 2000/05/17
Message-ID: <3922AC33.E378B61E@bangor.ac.uk>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US