Re: 2 instances (2 users) and security

HARI OM wrote:
> THANKS David.
>
> I am having 2 Instances... because of them server different purposes.
>
> SO you are tring to say NOT to have 2 users (caluser, bomuser) but to
> use SYS to control each Instance.
>
> In this case... we have:
> Instance: CAL
> User: SYS
> Pass: aronld
>
> Instance: BOM
> User: SYS
> Pass: billgates
>
> So, will above address thje security problem?
> Becasue SYS (of CAL) does not know password for SYS (of BOM).... am i
> right?
>
> THANKS again!
>
> HARI OM
You are so far wrong it isn't funny.

At the moment you have TWO users who can ACCESS EACH OTHER'S DATABASES AS SYS by virtue of their Linux user group. THIS IS NOT SECURE.

Two schemas would be JUST as secure, or more so, for the data as the two INSTANCES you now have, and the associated users would NOT have DBA privileges, thus keeping them from accessing data each should not see.

You've missed the ENTIRE point of the discussion thus far, and you have a nagging propensity to leap first and look later. This configuration you currently have needs to be dismantled and re-thought BEFORE you decide to implement ANYTHING.

And, before you do, hire a competent professional to handle these duties, as you have shown yourself unfit.

David Fitzjarrell Received on Fri Jun 10 2005 - 19:34:14 CDT