Link to home
Start Free TrialLog in
Avatar of sakthikumar

asked on

how to give grants on oracle types.

I created one oracle object type.
and created a table type based on the object.

now I wanted to give the grants on the above to another user.

So, I gave all privilege (using grant all on option) to another user for both.

then created synonym in the other user like,
create synonym synonym_name for user.object

create synonym synonym_name for user.table_type.


I dont know what is missing, but the object or table type is not accessible from java
from the granted user.

in user_tab_privs_recd, I am not able to find the object.?

what could be the problem?
Avatar of Sean Stuber
Sean Stuber

are you sure you didn't miss anything?

grant execute on user.object to some_user;

what do you see in the privileges view?

can you post something more specific? objects, errors, syntax used, etc?
Avatar of sakthikumar


I can able to use that object in plsql developer test window, but when using from java,

getting error like : error reading collection,

but the same he can do without any problem in other user where the type is created..

I am not sure where the problem is.
Avatar of Sean Stuber
Sean Stuber

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial