[cap-talk] capabilities in relational databases

[John McCabe-Dansted]

On Sun, Apr 13, 2008 at 1:24 AM, Rob Meijer <capibara at xs4all.nl> wrote:
>  >   a: CREATE VIEW vt AS SELECT * FROM t WHERE n < 10;
>  >   a: GRANT SELECT ON vt TO bob;
>
>  To me it would appear that something like the following would be much more
>  in line with the capabilities paradigm:
>
> CREATE VIEW a7b3npqs87g3nchly682 AS SELECT * FROM t WHERE n < 10;
>  GRANT SELECT ON a7b3npqs87g3nchly682 TO ALL

Or perhaps something like:

SQLFunction foo (SQLTable t, SQLFunction bob) {
    SQLView vt;
    CREATE VIEW vt AS SELECT * FROM t WHERE n < 10
    return bob(vt);
}

 or

SQLFunction foo (SQLTable t, SQLAppendableTable bob_mbox) {
    SQLView vt;
    CREATE VIEW vt AS SELECT * FROM t WHERE n < 10
    INSERT INTO bob_mbox ("vt",vt,"Hi, bob, here are the figures you
requested.")
}

-- 
John C. McCabe-Dansted
PhD Student
University of Western Australia