This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JDBC and the fly likes oracle.sql.STRUCT and db user rights Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "oracle.sql.STRUCT and db user rights" Watch "oracle.sql.STRUCT and db user rights" New topic
Author

oracle.sql.STRUCT and db user rights

Jina Lu
Greenhorn

Joined: Jul 09, 2010
Posts: 21
Maybe someone could explain me what action is called in database when in java 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.
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3435
    
  47

You need to grant the EXECUTE privilege to users that should be able to use your type.

Edit: see also http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_8001.htm
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: oracle.sql.STRUCT and db user rights
 
Similar Threads
Reading UDT values using JDBC
hbm2ddl.auto
Need Expert Advice
Iterating oracle.sql.STRUCT in java
probleme with datasource configuration