Re: View Security

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 31 May 2007 06:44:49 -0700
Message-ID: <1180619089.170752.202130@u30g2000hsc.googlegroups.com>

On May 31, 9:01 am, Brad <bemoor..._at_yahoo.com> wrote:
> Hi All,
>
> I'm new to Oracle DB's and have a basic question about update access
> to data through views. Is it possible for a user with the update
> privilege to a view, like sys.dba_audit_trail to make changes to the
> data they can access through the view and if so, do they require
> update to the table as well - AUD$?
>
> Thanks for any help.
>
> Brad.

Hi Brad,

You can create a view with a READ ONLY clause(http://downloadeast. oracle.com/docs/cd/B19306_01/server.102/b14200/ statements_8004.htm#i2065510), and regardless, a user does need write access to the underlying table whether or not the view is READ ONLY.

tahiti.oracle.com has tons of good stuff for question such as this.

HTH, Steve Received on Thu May 31 2007 - 08:44:49 CDT