Re: How to create a synonym for a role?

In article <822393250.17496.0_at_ccvm.sunysb.edu>, Olivier ZILLER <ziller_at_PRESN2.U-NANCY.FR> writes
>Hi,
>
>I need to create a synonym for a role but every time i try to do this :
>
> create synonym <role>.<table> for <user>.<table>;
>
>i get : ORA-01917: user or role '' does not exist

A role can't own synonyms (or any other kind of database object). A synonym is either private or public with nothing in between. --
Jim Smith Received on Thu Jan 25 1996 - 14:50:52 CST