Re: HOW TO? 2 or more users using the same schema?

On Tue, 29 Aug 2000 20:13:12 GMT, "Patrick Joyal" <please.reply_at_to.the.newsgroup> wrote:

>Hi,
>
>is there a quick way to have 2 or more users using the same schema, without
>having to grant privileges on every object and creating synonyms for every
>objects?
>
>I could use the same account for each user, but I want to keep a trace for
>each
>user.
>
>In other words, I want one schema, and many user using that schema like if
>it was their own
>schema.
>
>
>thanks for your help
>
>Patrick
>
>

Easy:
create a role
assign privileges to the role
grant the role to multiple users
create public synonyms for each object in your schema.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Aug 30 2000 - 00:54:24 CDT