Re: SqlBase, Informix ==> Oracle

You can ungrant that priv. Or create 5 different logins and for each login create a private synonym. then grant access the way you want to. Jim
"Franky Thiel" <franky.thiel_at_infohos.be> wrote in message news: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 Fri Oct 12 2001 - 03:08:05 CEST