Re: Dumb question about Users & Instances

neil,

never introduce a question with 'dumb' you never know what flames that might attract!

determine how the user was deleted -- was it with the DROP user command or via a custom utility that is keeping 3 instances in sync?

the comments on replication are also relevant -- was the DROP user replicated to the other 2 databases? this would seem to be the only non-custom way this could happen.

another possibility would be database triggers for a kind of home-grown replication

also, verify the configuration of the database schemas via DBA_USERS and init.ora settings -- is the schema really gone in all databases or was some external authentication mechanism disrupted that makes it look like the user is gone in all 3 instances?

• mcs

"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?
>
> 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.
>
> 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?
>
> Thanks
>
> Neil
>
>
Received on Thu Oct 30 2003 - 09:15:19 CST