UDTs and Java

[engineer2100]

Hi All,

I am facing a typical issue using Types in Java.

Scenario

I have two schemas A and B.

I have all Types created in Schema A i.e A is the owner of the Types.

I also have a role Role_X that has been granted EXECUTE priv on these types.

Now the Role (Role_X) has been granted to Schema B.

Issue

My front end code (java) connects to Schema B and makes use of these types.

The code fails throwing an error - Invalid type

Am I missing anything here.

Please help.

Thanks,
Engi

 

[engineer2100]

Added to this. The code works if i directly connect to Schema A (the owner of Types)

 

[Beilstwh]

A procedure can't use privs assigned via a role. If you directly assign the privs to Schema B, your code will work.

Bill
Oracle DBA/Developer
New York State, USA