Hi all, I'm looking to get the users of a role as well as the roles of a user.
I can do this with HsqlDB with the following two queries respectivly: - SELECT GRANTEE FROM INFORMATION_SCHEMA.ROLE_AUTHORIZATION_DESCRIPTORS WHERE ROLE_NAME=? - SELECT ROLE_NAME FROM INFORMATION_SCHEMA.ROLE_AUTHORIZATION_DESCRIPTORS WHERE GRANTEE=? AND ROLE_NAME!=GRANTEE But I couldn't find anything for H2, thanks for your help... -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/f1cd1730-bbe6-4360-afcd-0e89723e5dc6n%40googlegroups.com.
