Hi Sherman, 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://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 4 Aug 2011, at 14:16, Sherman Monroe wrote: > Hi Ivan, > > I tried removing the SPARQL, also, I gave dba all roles and all grants. I now > get this error: > > Virtuoso 42000 Error SR186: No permission to execute procedure > DB.DBA.SPARQL_INSERT_DICT_CONTENT with user ID 106, group ID 106 > > SPARQL query: > > #output-format:text/html > INSERT IN GRAPH <http://BookStore.com> > { <http://www.dajobe.org/foaf.rdf#i> <http://purl.org/dc/elements/1.1/date> > <1999-04-01T00:00:00> . > <http://www.w3.org/People/Berners-Lee/card#i> > <http://purl.org/dc/elements/1.1/date> <1998-05-03T00:00:00> . > <http://www.w3.org/People/Connolly/#me> > <http://purl.org/dc/elements/1.1/date> <2001-02-08T00:00:00> } > > -sherman > > On Sat, Jul 30, 2011 at 10:57 PM, Ivan Mikhailov <[email protected]> > wrote: > Hello Sherman, > > > Virtuoso 37000 Error SP030: SPARQL compiler, line 3: syntax error at > > 'SPARQL' before 'INSERT' > > > > SPARQL query: > > > > #output-format:text/html > > define sql:signal-void-variables 1 SPARQL INSERT IN GRAPH > > <http://BookStore.com> > > { <http://www.dajobe.org/foaf.rdf#i> <http://purl.org/dc/elements/1.1/date> > > <1999-04-01T00:00:00> . > > <http://www.w3.org/People/Berners-Lee/card#i> > > <http://purl.org/dc/elements/1.1/date> <1998-05-03T00:00:00> . > > <http://www.w3.org/People/Connolly/#me> > > <http://purl.org/dc/elements/1.1/date> <2001-02-08T00:00:00> }; > > When used in stored procedure or called via ISQL, it should be > SPARQL define sql:signal-void-variables 1 INSERT IN GRAPH ... > When called via SPARQL web service endpoint, the SPARQL keyword is not > needed at all. > > "SPARQL" is a Virtuoso SQL keyword that indicates where SPARQL-to-SQL > front-end should start to read the text (and to replace the source > SPARQL text with compiled SQL fragment). So it should be placed before > DEFINE. Web service endpoint does not need this keyword because it does > not expect anything other than SPARQL and it don't have to distinguish > between SPARQL and surrounding SQL. > > Best Regards, > > Ivan Mikhailov > OpenLink Software > http://virtuoso.openlinksw.com > > > > > > -- > > Thanks, > -sherman > > I pray that you may prosper in all things and be healthy, even as your soul > prospers > (3 John 1:2) > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > http://p.sf.net/sfu/rim-blackberry-1_______________________________________________ > Virtuoso-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
