Re: how let other users access my tables?

How is another_user referencing the table?

try select * from table_owner.myTable

Or create a public synonym ...

banghe <banghe_at_baileylink.net> 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
  Received on Mon Dec 18 2000 - 15:13:43 CST