Re: SqlBase, Informix ==> Oracle
From: Gleb Shulman <glebsky_at_gmx.net>
Date: 11 Oct 2001 19:29:59 -0700
Message-ID: <8ff19c60.0110111829.46dbee30_at_posting.google.com>
Date: 11 Oct 2001 19:29:59 -0700
Message-ID: <8ff19c60.0110111829.46dbee30_at_posting.google.com>
"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.
>
Well, create users in oracle with empty schemas. Than do
sql> grant select on schema_for_databaseX.tableY to userZ;
sql> create synonym tableY for schema_for_databaseX.tableY;
You may grant something else if you need but your userZ will be able to drop only synonym. Received on Fri Oct 12 2001 - 04:29:59 CEST