[Info-ingres] Can we have a grant update excluding (columnlist)?

[Martin Bowes]

The answer is that the update excluding is stored properly.

grant update excluding (data_id) on "webfu".diet24 to user martinb;

Marty

From: Martin Bowes [mailto:martin.bowes at ndph.ox.ac.uk]
Sent: 25 April 2019 10:35
To: Adrian Williamson; info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Can we have a grant update excluding (columnlist)?

I haven't managed to track down the culprit yet.

London to a brick they cut and pasted a help table command.

Although a part of me is now wondering if they did do an update excluding() and this is the way it was stored in the catalogs.

I'd better check that out before I go in there breathing fire.

Marty

From: Adrian Williamson [mailto:adrian.williamson at rationalcommerce.com]
Sent: 25 April 2019 10:28
To: Martin Bowes; info-ingres at lists.planetingres.org
Subject: RE: [Info-ingres] Can we have a grant update excluding (columnlist)?

Hi,

What they didn't write a script to create the 'grant update' from the iicolumns view?

That's a training issue that is...

Cheers

Adrian

From: info-ingres-bounces at lists.planetingres.org <info-ingres-bounces at lists.planetingres.org> On Behalf Of Martin Bowes
Sent: 25 April 2019 10:13
To: info-ingres at lists.planetingres.org
Subject: [Info-ingres] Can we have a grant update excluding (columnlist)?

Hi All,

We have a table with 785 columns. Some clown has just written an update grant which was specific to all but 11 columns of that table.

Yes they really wrote down...
grant update (dfinished, pagemodify, viewing_page, ....over 700 names later , yesterday_ill_any, typical_ny, portion_size) to ...

I'm now going to find out why it was so vital not to grant update on those remaining 11 columns.

That should be a fun conversation.

Martin Bowes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20190425/e5f74fe2/attachment.html>