This content has been marked as final. Show 4 replies
There is no need for DBA privilege, except at the semantic network creation time.
Let me describe a scenario. Assume two regular DB users A and B.
A creates an application table table_a, associate a semantic model model_a with it.
Now, B cannot perform insert, update, or query against model_a.
A can do all of that of course.
A can grant DML privileges to B on the application table so that B can add/remove triples etc.
Or, A can grant select on MDSYS.SEMM_MODEL_A to B. Then B can query the data.
thank your quick response. I have granted select on mdsys.semm_rdf_family to rdf_user.but I still got the following errors same as before running the granting.it looks that rdf_user can't see model "RDF_FAMILY".Any good ideas and suggestions?
ERROR at line 1:
ORA-55300: model "RDF_FAMILY" does not exist
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 176
ORA-06512: at line 1
Ooops, forgot another one.
You need to do "grant select on mdsys.rdfm_RDF_FAMILY to rdf_user"
RDFM_ and SEMM_ are both prefixes for models.
Thank you very much, it's OK now. thank you.