Re: How to assign multiple users to same schema?

"Rayess" <rayess_at_mail.com> wrote in message news:8jti0a$ud9$1_at_nnrp1.deja.com...
> When I create a user, Oracle creates a schema for that user. But what
> if I want to have many users sharing the SAME schema (with tables,
> etc...). How would I do that?

        Create synonyms in each users schema. Grant public or private access to objects in the master schema.

> Thanks.

        No problems, I am sure that you will get many more answers.

> Sent via Deja.com http://www.deja.com/
> Before you buy.

        Regards.

Tony

--
S. Anthony Sequeira

Totally committed to the fifty bucks

Opinions expressed herein are my own and do
not necessarily represent those of my employer