Originally posted by mike cool:
hi
i use derby with java but i have some Q:
1-how can i create new user in my database using sql query
2-what sql dialect derby uses, and where can i find some references (like ms sql book online)
thx
Let's start with your 2nd question first:
Derby (like many other databases) more-or-less implements SQL-92, SQL-99 and SQL-2003, focusing on core/mandatory features. However, there's enough missing that no-one could really call it compliant with any of those standards. See:
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures The Apache project has online documentation of the SQL that Derby supports, here:
http://db.apache.org/derby/docs/dev/ref/ Additionally, Derby is derived from IBM's Cloudscape, which IBM donated to Apache. So far as I know, not too much has changed, so IBM's documentation is still pretty useful:
http://publib.boulder.ibm.com/infocenter/cldscp10/index.jsp?topic=/com.ibm.cloudscape.doc/sqlj.htm You will quickly note that Apache's documentation organization still parallels IBM's...
For your first question, I don't really know; I've only used Derby/Cloudscape as an embedded DB, single user. It sort of looks as if each "user" is the database owner, so you specify a new user by creating a new "database".
