db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Wikipage SQLvsDerbyFeatures & 10.2 grant/revoke
Date Tue, 05 Sep 2006 12:12:38 GMT
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

View raw message