The Geek Shall Inherit the Earth.
I wanted to see all users who had localdbs on our server.
select * from user_role_privs
..will list all the users roles. The user with SSE_ROLE permissions are registered developers, and they could have local dbs.