Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "oracle.sql.STRUCT and db user rights" Watch "oracle.sql.STRUCT and db user rights" New topic

oracle.sql.STRUCT and db user rights

Jina Lu

Joined: Jul 09, 2010
Posts: 26

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

Joined: Aug 22, 2010
Posts: 3728

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

Edit: see also
I agree. Here's the link:
subject: oracle.sql.STRUCT and db user rights
It's not a secret anymore!