Does your IDM_ACE_DEVELOPER user have the Catalog Read System Privilege with Grant Option assigned?
You can easily check this with following SQL:
select * from effective_privileges where user_name = 'IDM_ACE_DEVELOPER' and object_type = 'SYSTEMPRIVILEGE' and privilege = 'CATALOG READ';
It is necessary that the Grant Option is set, otherwise the user is not allowed to grant the privilege to another user. In the result of the above SQL you can see that in column IS_GRANTABLE.
Regards,
Florian
Florian,
Sorry I was a little late getting back to you, but you seem to be exactly correct. I ran the query you suggested, and sure enough, my IDM_ACE_DEVELOPER user was set to fale for IS_GRANTABLE.
Using my SYSTEM user, I modified my IDM_ACE_DEVELOPER user to make everything showing up in SYSTEM Privilege tab to Grantable.
I then ran my JDBC, and did not receive any errors this time, and when I double checked my TESTUSER id, it had CATALOG READ.
Very nice, and I very much appreciate your assistance!
Add comment