Re: how let other users access my tables?

You either need to create a private or public synonym or you need to prefix the tablename with the owner.

Regards,

Sybrand Bakker

BTW: IMO using 'with grant option' is one of the safest ways to loose control over security.
Create a role, grant your tables to the role, and grant the role to the user, and no need to use 'with grant option'

"banghe" <banghe_at_baileylink.net> wrote in message news:3A3E71F1.218199F3_at_baileylink.net...
> Hello,
>
> I created myTable and issued:
> sql> grant all on myTable to another_user with grant option;
>
> Why the another_user still cannot see myTable?
>
> Even I grant the system privilege "access any table" to another_user,
> still doesn't work.
>
> Thanks,
>
> --Bangh
>
Received on Mon Dec 18 2000 - 14:44:36 CST