Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Access to models not owned by a user

758021Mar 4 2010 — edited Mar 5 2010
Hello all,

We were ready to deploy a semantic project with Oracle 11.2 and Java (Jena Adaptor). But we have come across a problem. The client (a gov administration) expects users in the db managed this way:

User SYS: DBA user who creates the semantic network.
User APP_ADMIN: create models (and correspondent tables) for the application.
User APP_FUNC: select, inser, update, detele rdf triples on the application models. All grants conceded over mdsys.rdfm_model, mdsys.semm_model and even the model table owned by APP_ADMIN.

The APP_FUNC user can read correctly the models. But all write operations resut in the next exception:
------
SLF4J: The requested version 1.5.8 by your slf4j binding is not compatible with [1.5.5, 1.5.6]
SLF4J: See http://www.slf4j.org/codes.html#version_mismatch for further details.
813 [main] WARN oracle.spatial.rdf.client.jena.GraphOracleSem - Could not perform query
java.sql.SQLException: ORA-00942: la tabla o vista no existe

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.sendBatch(OraclePreparedStatement.java:3753)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.sendBatch(OraclePreparedStatementWrapper.java:1140)
at oracle.spatial.rdf.client.jena.GraphOracleSem.flushAdd(GraphOracleSem.java:1400)
at oracle.spatial.rdf.client.jena.GraphOracleSem.graphBaseFind(GraphOracleSem.java:2427)
at oracle.spatial.rdf.client.jena.GraphOracleSem.graphBaseFind(GraphOracleSem.java:2297)
at oracle.spatial.rdf.client.jena.GraphOracleSem.graphBaseFind(GraphOracleSem.java:2164)
at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240)
at org.fundacionctic.ogd.data.support.OracleSupport.testInsertarDatos(OracleSupport.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
------

Seem like the user cant 'see' the tablesor views. Even when the APP_FUNC user is given DBA role, the exception is thrown. Actually we cant think of any solution. So far we had not had this problem because we used the same user to create the model and do all operations on them.

So the question is.. Only the owner of a model can make operations on it through the jena adaptor? Is there any way to change that? And if not... Is there any kind of official documentation on this issue so we can justify this change in the administration?

Hoping need, thanks.

Comments

Robin Chatterjee

usually you need to raise an issue on the beehive forum if you face a resource issue.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 2 2010
Added on Mar 4 2010
3 comments
2,213 views