Re: SqlBase, Informix ==> Oracle

From: Franky Thiel <franky.thiel_at_infohos.be>
Date: Thu, 11 Oct 2001 16:35:44 +0200
Message-ID: <3bc5ae40$0$21085$ba620e4c_at_news.skynet.be>


But if they can connect as the owner of th etable they also can drop the table and that's a thing that I don't want.

Regards,

Franky
"Jim Kennedy" <kennedy-family_at_home.com> schreef in bericht news:QThx7.23612$JN.79946_at_news1.sttls1.wa.home.com...
> Create 5 logons where each logon is the owner of the tables in the schema.
> Then you don't have to prefix the table name with the owner name.
> Jim
> "Franky Thiel" <franky.thiel_at_infohos.be> wrote in message
> news:3bc58863$0$21080$ba620e4c_at_news.skynet.be...
> > Now we are working with SqlBase and Informix and have created a 5
 databases
> > for 1 project. We now want to convert to Oracle but in Oracle you create
 1
> > database and in that database you create 5 times a schema. The problem
 is
> > that we have tables with the same name in schema 1 and in schema 3. In
> > Sqlbase it was in database 1 & 3. If we create public synonyms in Oracle
 whe
> > have a problem because some tables exists in database 1 & 3.
> >
> > If we want to do a select in Oracle we must do SELECT ..... FROM
> > owner.tablename instead of SELECT ... FROM tablename and that's because
 we
> > cannot create the public synonyms.
> > Is there another solutions for this because otherwise we had to change
 all
> > our select statements in our applications.
> >
> >
> > Thanks for your help,
> >
> >
> > Franky
> >
> >
>
>
Received on Thu Oct 11 2001 - 16:35:44 CEST

Original text of this message