Hi, extremely urgent (apologies) I can't get insert to work over SPARQL at all; I've given SPARQL user SPARQL_UPDATE role; but error is:
42000 Error SR186: No permission to execute procedure DB.DBA.SPARQL_INSERT_DICT_CONTENT. tried the grant way and getting errors all over: SQL> GRANT SELECT ON DB.DBA.SPARQL_DELETE_DICT_CONTENT TO "SPARQL"; *** Error 42S02: [Virtuoso Driver][Virtuoso Server]SR136: Bad table name in GRANT / REVOKE DB.DBA.SPARQL_DELETE_DICT_CONTENT. at line 1 of Top-Level: GRANT SELECT ON DB.DBA.SPARQL_DELETE_DICT_CONTENT TO "SPARQL" SQL> GRANT SELECT ON DB.DBA.SPARQL_INSERT_DICT_CONTENT TO "SPARQL"; *** Error 42S02: [Virtuoso Driver][Virtuoso Server]SR136: Bad table name in GRANT / REVOKE DB.DBA.SPARQL_INSERT_DICT_CONTENT. at line 2 of Top-Level: GRANT SELECT ON DB.DBA.SPARQL_INSERT_DICT_CONTENT TO "SPARQL" any quick ways to get this working without rebuilding; I've onyl got a few hours left before live and need to get some triples saving and deleting via sparql. maybe i can drop and recreate the procedures if you have the code for them?? regards, nathan
