Re: How to assign multiple users to same schema?

Creaete a schema and create allobjects under that schema. Then give privelleges on that object to all the users that need to refrence them. Then you can create public synonyms for all of the objects.

Hope this helps.

Neeraj Verma

 neerajv_at_email.msn.com
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?
>
> Thanks.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jul 04 2000 - 00:00:00 CDT