A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
The Java EE 7 Tutorial Volume 1 or Volume 2
this week in the
jQuery UI in Action
oracle.sql.STRUCT and db user rights
Joined: Jul 09, 2010
Oct 12, 2012 04:26:51
Maybe someone could explain me what action is called in database when in
we are creating new oracle.sql.STRUCT object?
Struct struct = new STRUCT(StructDescriptor.createDescriptor("SCHEMANAME.TEST", dbOracleConnection), dbOracleConnection, myMap);
I needed to check if all required rights are provided to db user.
Thanks a lot in advance.
Joined: Aug 22, 2010
Oct 12, 2012 04:34:09
You need to grant the EXECUTE privilege to users that should be able to use your type.
Edit: see also
It is sorta covered in the
JavaRanch Style Guide
subject: oracle.sql.STRUCT and db user rights
probleme with datasource configuration
Reading UDT values using JDBC
Iterating oracle.sql.STRUCT in java
Need Expert Advice
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014