This content has been marked as final. Show 2 replies
Check your queries, for example, to map oracle db users and roles you can use something like this:
SQL Is Member: SELECT DISTINCT grantee FROM dba_role_privs WHERE granted_role = ? AND grantee = ? SQL List Member Groups: SELECT granted_role FROM dba_role_privs WHERE grantee = ?
thanks for the repply. After tests I found that the Integration of the SecurityProviders was not working because of different Passwords on LDAP and DB-level.. I was irretated, since I expected to see the member groups of each user, delivered from the ReadOnlySQLAuthenticator..