Re: Dumb question about Users & Instances

Comments embedded

"zoetosis" <NeilJellis_NoSpam_Please__at_Hotmail.com> wrote in message news:<bnqtl1$q6i$1$8300dec7_at_news.demon.co.uk>...
> I know this is a dumb question but not being a dba I can't find a quick
> answer to it.
>
> On a machine running 3 instances are the users in one instance totally
> independent of those in another?

Yes

>
> I've just been told that a client deleted a user in one instance and that
> that user disappeared from the other two instances as well.

So you don't have three instances.
>
> I always thought that the user "fred" could be created in each of the
> instances but that each user was specific to the instance in which they were
> created, is this correct?
>

Yes, unless you use special tools.
> Thanks
>
> Neil

Sybrand Bakker
Senior Oracle DBA Received on Thu Oct 30 2003 - 08:11:38 CST