Re: Help needed urgently

In article <3A00F193.97552344_at_starnet.gov.sg>,   Ong Yeow Hin <oyeowhin_at_starnet.gov.sg> wrote:
> I have a few databases (from different department) residing on 1
> machine. Currently, there is 1 DBA maintaining all the databases. My
> boss would like to distribute the management of the database to the
> various department as follows:
> - 1 DBA for each Database
> - The DBAs will not be able to manage other databases except the one
 he
> is authorised
>
> 1) How to implement the above

Password files. A separate password file per database, with each init.ora setting 'remote_login_passwordfile' to EXCLUSIVE. Make sure you change the Internal and SYS passwords for each Instance/Database.

I think that's your only choice on Unix. On NT, you can set up multiple groups on the one box, with the SID as a differentiator, and make sure that the group memberships are distinct for each one.

> 2) Is it recommended to have this kind of setup and are there any
> implications.
>

It's hardly an issue that warrants a recommendation or not: if your circumstances require it, the facility is there to achieve it. The only implications I can see are a lot of fiddling to start with setting it up right.

Regards
HJR
> I would appreciate if anyone could advise. Thanks in advance.
>
> Rgds,
> YH
>
>

--
======================================================
'Baldric, you wouldn't recognise a cunning plan if it
painted itself blue, and danced naked on top of a
harpsichord singing 'Cunning Plans Are Here Again!'


Sent via Deja.com http://www.deja.com/
Before you buy.