Re: database security
Date: 30 Oct 1994 00:29:06 -0400
Message-ID: <38v7ei$1iq_at_newsbf01.news.aol.com>
In article <38oh1r$1sa_at_raffles.technet.sg>, shchua_at_solomon.technet.sg (Chua Song Heng) writes:
>Suppose there are 2 databases on a server and I have 2 database
>administrators taking charge of one each.
>Is there any way to control access such that each DBA can only access the
>database he is in charge of?
>(database is on version 7)
>Prompt reply is appreciated.
>Thanks!
Setting different passwords for the DBA roles in each database instance
will
take care of much of the issues.
Its the unix oracle account that you should be concerned with. Access to
the
oracle account is for upgrades, patches, or data file creation. Access
outside these functions should be virtually nil.
You need to allow both, one or neither this access. One could be
responsible for
upgrades and patches. But both may need to extent tablespaces by creating
additional datafiles; this should not occur too often. Received on Sun Oct 30 1994 - 05:29:06 CET