Re: Dumb question about Users & Instances

Answers in-line.

zoetosis wrote:

>I know this is a dumb question but not being a dba I can't find a quick
>answer to it.
>

Why? Don't you have a DBA? Who set i tup? Who is managing it?

>On a machine running 3 instances are the users in one instance totally
>independent of those in another?
>

Yes. But it is not much different from them being in separate schemas.

>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.
>

Nonsense unless replication is in place. And total nonsense if anyone is giving "a client" the privilege
to delete a schema. That's just plain ridiculous.

>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
>
>

You thought correctly. So my guess is that someone has instituted some form of
replication.

But it still leaves open the question of who is responsible for this mess? And why the
apparently intense desire to violate good security practices. Well good practices period
as I can't find anything in your posting the justifies having more than a single instance.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)