Re: Refuse DBA access to a schema?

Sounds like a job for trusted Oracle.

The only other way to do it in the database is to encrypt everything.

Jared

On Fri, 23 Jun 2000, Sherwin Anthony Sequeira wrote:

> Hi guys and gals,
>
> I have a good one here.
>
> The customer has a DB that is run and maintained in the States, i.e.
> All DB Admin is done over there.
>
> The DB has a schema, which has highly sensitive material.
>
> What the customer wants, is to lock out SYS and SYSTEM, and any other
> DBA accounts from the application schema.
>
> Off the top of my head, I can think of no way of doing this.
>
> Any ideas?
>
> Regards.
>
> Tony
> --
> S. A. Sequeira
>
>
> --
> Author: Sherwin Anthony Sequeira
> INET: sherwin_at_sequeira.ezesurf.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Fri Jun 23 2000 - 16:23:01 CDT