Re: synonym problem

A role can't own database objects, e.g. tables, views, synonyms, etc. You either need to create public synonyms which the role can use, or private synonyms for each user in the role TST_USER.

Pekka Penttila <cpt2ppa_at_u.comptel.fi> wrote in article <Pine.HPP.3.95.961015173107.12000A-100000_at_amfi.u.comptel.fi>...
> How I can create synonym where shema is role. t.ex. role name is tst_user
> and table owner is scott and tablename is office, I tried create synonym:
> create synonym tst_user.office for scott.office;
> Oracle says:
> ORA-01917: user or role '' does not exist
>
> If it's possible make synonym for role, how can I do it?
> I use oracle 7.1.4.xx and HP700
>
> Regards,
> Pekka Penttila
>
> email: pekka.penttila_at_comptel.fi
>
>
  Received on Sun Oct 20 1996 - 00:00:00 CEST