tom_ wrote:
Isn't there a possibility to select the database users from the systables? In the documentation I've not found it.
Hi Tom,
I may be missing the point of your question, but here's some more information: Derby doesn't have a system table which stores the names of users who are allowed to connect to a database. This is because authentication can be (perhaps usually is) handled by an external service such as an LDAP server. Derby authentication is described in the "Working with user authentication" section of the Derby Developer's Guide: http://db.apache.org/derby/docs/10.3/devguide/
I think that the closest that you can get to what you want is to list out the authorization ids of the schemas in a Derby database. The authorization ids are the names of the users who own those schemas. The following query will give you those user names:
select distinct authorizationid from sys.sysschemas This will give you the names of some of your users. Hope this helps, -Rick
