db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Select users from systables
Date Wed, 09 Jan 2008 20:31:08 GMT
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

Mime
View raw message