I'm going to update the http://wiki.apache.org/db-derby/SQLvsDerbyFeatures (anyone is free to do so.... ;-)
Question: Is my interpretation of what has been implemented correct? E081 Basic Privileges E081-01 SELECT privilege at the table level Yes E081-02 DELETE privilege Yes E081-03 INSERT privilege at the table level Yes E081-04 UPDATE privilege at the table level Yes E081-05 UPDATE privilege at the column level Yes E081-06 REFERENCES privilege at the table level Yes E081-07 REFERENCES privilege at the column level No E081-08 WITH GRANT OPTION No E081-09 USAGE privilege No E081-10 EXECUTE privilege Yes F031-19 REVOKE statement: RESTRICT clause Yes F311-05 GRANT statement Yes F034 Extended REVOKE statement No F034-01 REVOKE statement performed by other than the owner of a schema object No F034-02 REVOKE statement: GRANT OPTION FOR clause F034-03 REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION No F231 Privilege tables F231-01 TABLE_PRIVILEGES view No F231-02 COLUMN_PRIVILEGES view No F231-03 USAGE_PRIVILEGES view No F731 INSERT column privileges No T211-07 TRIGGER privilege Yes T281 SELECT privilege with column granularity No -- Bernt Marius Johnsen, Database Technology Group, Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems, Trondheim, Norway
signature.asc
Description: OpenPGP digital signature
