db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manjula G Kutty <manjula.ku...@gmail.com>
Subject Question about Grant/Revoke
Date Wed, 15 Mar 2006 23:16:52 GMT
Hi ,
 I was investigating the Grant/Revoke functionality added till now. And 

ij> connect 'jdbc:derby:grantdb;create=true' user 'mkutty';
ij> create table t1 (i int, j int);
0 rows inserted/updated/deleted
ij> grant select on t1 to mkutty;
ERROR 42Z60: GRANT not allowed unless database property 
derby.database.defaultConnectionMode has value 'sqlStandard'.

I know as per Derby docs the 'derby.database.defaultConnectionMode' 
property specifies the default access permission and can have values 
like "noAccess", "readOnlyAccess", or "fullAccess". So I think the above 
error message is misleading.

I'm using the following derby jars

[C:\pantry\derby.jar] alpha - (384095)
[C:\pantry\derbytools.jar] alpha - (384095)

Also to mention that if I'm not mistaken I have to put the 
derby.database.sqlAuthorization property only for upgrading derby from 
version10.1 right?  I came to this conclusion because I found the 
follwing sentences on the functional spec under "*derby upgrade and 


When a database is created, if derby.database.sqlAuthorization property 
value is true, the database gets created with standard security mode, 
enabling grant and revoke. This property could be set either as a system 
property in derby.properties file or as application property.

But the following lines caught my attention

It may be good to switch the default connection mode to standard model 
and hence support grant/revoke by default in future releases.

Is this being implemented?

Can any one please clarify?


View raw message