Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HOW TO? 2 or more users using the same schema?
There is another way but it depends on which oracle you are using.
In oracle 8i there is invoker rigth.
so user x can execute a procedure which is owned by user y and user x data
gets updated.
Tom
Patrick Joyal <please.reply_at_to.the.newsgroup> wrote in message
news:39ac256f_at_news...
> 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
>
>
>
Received on Wed Aug 30 2000 - 02:30:12 CDT