Deepa Remesh wrote: > > Thanks for clarifying this Satheesh. I tried this by setting it as a > database property for the upgraded database. However, grant/revoke > does not work right away. It works after I shutdown/reconnect to the > database. Is this the expected behaviour for this property? If so, it > may be good to add this to the spec and documentation. > Right... sqlAuthorization property is a "static" property so it needs a database recycle to take effect. Dynamic properties take effect immediately. Static/dynamic properties are discussed more here, just FYI. http://db.apache.org/derby/docs/10.1/tuning/ctunsetprop824615.html
I will include this in the spec update. Satheesh
