synonym problem
From: Pekka Penttila <cpt2ppa_at_u.comptel.fi>
Date: 1996/10/15
Message-ID: <Pine.HPP.3.95.961015173107.12000A-100000_at_amfi.u.comptel.fi>#1/1
Date: 1996/10/15
Message-ID: <Pine.HPP.3.95.961015173107.12000A-100000_at_amfi.u.comptel.fi>#1/1
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 Tue Oct 15 1996 - 00:00:00 CEST