Sample Header Ad - 728x90

How to list known users on Apache Derby server?

0 votes
1 answer
30 views
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?
Asked by jf1 (101 rep)
Feb 13, 2025, 10:03 AM
Last activity: Feb 13, 2025, 02:01 PM