Re: Database security

Path: emory!att!linac!pacific.mps.ohio-state.edu!cis.ohio-state.edu!ucbvax!hplabs!pyramid!infmx!aland From: aland@informix.com (Colonel Panic) Newsgroups: comp.databases.informix Summary: updating thru views Message-ID: <1991Oct16.030122.25506@informix.com> Date: 16 Oct 91 03:01:22 GMT References: <6170@jethro.Corp.Sun.COM> <8566@ns-mx.uiowa.edu> <1991Oct11.010851.24423@sequent.com> Sender: news@informix.com (Usenet News) Organization: International Brotherhood of Geeks, Local 619 In article <1991Oct11.010851.24423@sequent.com> lugnut@sequent.com writes: >... >You cannot update a view, so set up their sql environ to go at a view >and reserve the real tables for the 4gl application... > >Don "or hire armed guards to watch their every move" Bolton Not quite true. You can update or insert thru an updateable view. An updateable view is a single-table view in which the underlying SELECT statement contains none of the following: * DISTINCT or UNIQUE * GROUP BY * Derived value (virtual column) * Aggregate value * rowid in the column list Also, you must have update privilege on the view itself, and the view creator must have update privilege on the underlying table. -- Alan Denney # aland@informix.com # {pyramid|uunet}!infmx!aland Our children call him "Daddy"; they refer to me as "Sir" In all our family pictures he is standing next to her For Christmas he bought her a pair of handcuffs and a whip Sometimes I think it's put a strain on our relationship -- "He's Just a Friend", Austin Lounge Lizards