Hello Nathan, Use GRANT EXECUTE ON, not GRANT SELECT ON ... and the grantee role is SPARQL_UPDATE. If you want to permit RDF data manipulations from the web service endpoint, do not grant permissions on individual procedures, instead, GRANT SPARQL_UPDATE to "SPARQL" (note mandatory double quotes and mandatory uppercase of "SPARQL" )
Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2009-12-08 at 21:47 +0000, Nathan wrote: > 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
