Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

oracle.sql.STRUCT and db user rights

 
Jina Lu
Greenhorn
Posts: 26
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 3751
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic