Re: Database in-security

Path: emory!samsung!uunet!ogicse!sequent!muncher.sequent.com!lugnut From: wyseass@secret.com Newsgroups: comp.databases.informix Summary: Nope, tis fall these days Message-ID: <1991Oct16.170113.18973@sequent.com> Date: 16 Oct 91 17:01:13 GMT References: <Available upon request> Sender: Return To (Address Unknown) Organization: Loyal Order Of The Design Profits And Spreadsheet Emporium In article <1991Oct16.030122.25506@informix.com> aland@informix.com (Colonel Panic) writes: >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 SINGLE TABLE VIEW? "how quaint" :-) >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. > THanks for the reminder, all the stuff I've done surpassed the updateable so I had forgotten there are prticular stances, on specific days, having specific barometric pressure, with exact windspeeds, coming from a general direction, that it would work. (if you hold your mouth right). Don "Its a beautiful day in the neighborhood" Bolton