Re: how let other users access my tables?

banghe wrote:

> 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

The need to preceed the table name with the schema owner for that table. For example, if the schema is xxx and the tablename is yyy then they must use xxx.yyy. There are two ways around this. They can either create a private synonym in their own account that references xxx.yyy or else the DBA can create a public synonym that references xxx.yyy. Received on Mon Dec 18 2000 - 15:12:01 CST