Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Synonym Performance
from 8.1.6 (or is it 8.1.7) the user and the
schema can be separated. Many users
can have access to a default 'enterprise' schema
without having to own a schema.
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk billmil_at_my-deja.com wrote in message <8bntpe$44u$1_at_nnrp1.deja.com>...Received on Mon Mar 27 2000 - 00:00:00 CST
>
>
>As a relative newcomer to Oracle, I was surprised how they enmeshed the
>concepts of "user" and "schema"; I have *never* seen an application where
>each person has his/her set of tables. In our situation, I created an
>application-user-schema-name ("LIN"), but wanted people to access the
>database through a less-powerful user to prevent accidents. I didn't know
>the overhead with synonyms.