In the documentation to Apache Derby I've seen documentation on functions to administrate user accounts. However, I did not manage to find documentation on how to get a listing of all registered users.
After failing to find a respective answer on a Web search likewise I tried all methods suggested by perplexity.ai, which just failed altogether:
SELECT * FROM SYS.SYSUSERS
"Table/View 'SYS.SYSUSERS' does not exist."
SHOW ROLES
"Syntax error: Encountered "SHOW" at line 1, column 1." and
SELECT * FROM SYS.SYSCS_UTIL.SYSCS_GET_ALL_PROPERTIES()
WHERE PROPERTY_NAME LIKE 'derby.user.%'
"Syntax error: Encountered "." at line 1, column 29.".
There is no derby.properties file either.
How can I get a listing of all known users?
