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
Last activity: Feb 13, 2025, 02:01 PM