Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Synonyms are a pain!
> I'm a little uncertain about private synonyms. I'd have to create a
set for
> each user, right? Then I'd have to grant the usual privileges (INSERT,
> DELETE, UPDATE, DELETE) to each user.
>
> If this is all correct, with 10-30 possible users, does it make any
sense to
> use private synonyms?
>
> Thanks very much >>> Robert
Only if two separate schemas share the same database instance and you have two distinct groups of users, one accessing one of the schemas:
user11, user12... access schema1
user23, user24... access schema2
Generally, the more users you have, the less attractive this option is. The only way out though is to split the database allowing each schema reside in its own database, then you could use public synonyms.
Kirill Richine
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri May 05 2000 - 00:00:00 CDT