Re: Object privilege at row level?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 25 Jul 2003 00:03:38 +0200
Message-ID: <vi1bamnb76sf02@corp.supernews.com>

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:22l0iv0tp71jjl3vs908ng5gc625qj0vf8_at_4ax.com...
> Is there a way (using Oracle 9.2.0) to control access to rows of a
> table? (Instead of granting access to the whole table)
>
> Can one at least monitor access to certain rows of a table?
> That is, is it possible to protocol who and when accessed certain
> rows?
>
> Thanks
> Rick Denoire

Yes, using Fine Grained Access Control, Row Level Security, Virtual Private Database, or whatever the most recent marketing term is. Available in EE only.
FGAC comes with Fine Grained Auditing.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Thu Jul 24 2003 - 17:03:38 CDT