legolas wood wrote:
I have some technical questions,
- What is differences between a database that have SQL authorization and
a database that does not have any SQL authorization? I mean is there any
changes in schema structure?
- Can we create a database with SQL authorization enabled in a server
environment without any property related to SQL authorization in
derby.properties?
- Is it possible to enable sql authorization for a database that is
created without any sql authorization ?
We have a database that has no SQL authorization because we were not
aware of this future in derby 10.2 and now we want to add SQL
authorization to it. I connect to database using a server that its
derby.properties has all SQL authorization property enabled, but we can
not execute any grant or revoke statement on it.
Does this help?
http://db.apache.org/derby/docs/10.2/devguide/cdevcsecure866060.html
Dan.