Re: SqlBase, Informix ==> Oracle

From: Franky Thiel <franky.thiel_at_infohos.be>
Date: Fri, 12 Oct 2001 16:45:19 +0200
Message-ID: <3bc701ff$0$36466$ba620e4c_at_news.skynet.be>

This seems to be a good idea, the only problem that I still have is that when I try

I connect as owner_table (oraapot) as sysdba

SQL> grant select on owner_table.tableY to userZ;

I get :

grant select on oraapot.aankoop to franthie

                        *

ERROR at line 1:
ORA-01031: insufficient privileges

PRIVILEGE SET FOR THAT USER (oraapot)

GRANT ANY ROLE
GRANT ANY PRIVILEGE but it still get the error message.
Any idea what I'm doing wrong ?

"Gleb Shulman" <glebsky_at_gmx.net> schreef in bericht news: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 - 16:45:19 CEST