Re: restricting table read access to admins

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Fri, 18 Nov 2005 19:11:16 GMT
Message-ID: <Xns971271E83BB2FSunnySD@70.168.83.30>

Mark Harrison <mh_at_pixar.com> wrote in
news:aToff.16807$7h7.16597_at_newssvr21.news.prodigy.com:

> I'm in charge of setting up a new oracle installation, and I'd
> like to read up access protection. Any particularly good
> resources to look at?
>
> In particular, I would like to restrict some tables of
> confidential information so that low-level system admins
> and operators can't see the data in some of the tables.
>

All of Oracle documentation can be found at: http://tahiti.oracle.com

If I am a *nix SA with root access, I can get to EVERYTHING in the DB. You therefore have 2 choices -
1) Trust your employees
2) encrypt the data & trust fewer employees Realize that somebody must be able to get to the "confidential information" otherwise it becomes write-only data & useless to everyone. Received on Fri Nov 18 2005 - 13:11:16 CST