Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to create a synonym for a role?

How to create a synonym for a role?

From: Olivier ZILLER <ziller_at_PRESN2.U-NANCY.FR>
Date: Tue, 23 Jan 1996 11:18:20 +0100
Message-Id: <9601231035.AA05291@alice.jcc.com>


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

but the role exist!

How to do this?
Olivier ZILLER
Service Informatique de Gestion
Universite NANCY2
25 rue Baron Louis
BP 454 NANCY CEDEX
tel: 83 34 46 04
e-mail : ziller_at_presn2.u-nancy.fr Received on Tue Jan 23 1996 - 05:35:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US