Re: [Virtuoso-users] Sparql INSERT / DELETE errors {SOS}

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 a

Re: [Virtuoso-users] Sparql INSERT / DELETE errors {SOS}

Hi Nathan, Try executing the following from isql as the "dba" user: grant execute on SPARQL_INSERT_DICT_CONTENT to "SPARQL" grant execute on SPARQL_INSERT_DICT_CONTENT to SPARQL_UPDATE Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http

Re: [Virtuoso-users] Sparql INSERT / DELETE errors {SOS}

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>

[Virtuoso-users] Sparql INSERT / DELETE errors {SOS}

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