Hello Rajeev, Ivan, and Hugh I ran the iSQL command: grant SPARQL_UPDATE to "SPARQL";
That granted me the permissions I needed to delete the records. Thanks for your help. I figured the SPARQL delete permissions would be turned off by default (as Ivan indicated). However, I was able to perform insert statements through the SPARQL endpoint before I granted SPARQL_UPDATE to the SPARQL user. I found this a little confusing. I would have expected both INSERT and DELETE permissions to be disabled by default. What is the scope of the SPARQL_UPDATE permission? Does it grant the ability to INSERT and DELETE? Or just DELETE? In the documentation on SPARUL (17.3. SPARUL) it seems to indicate that SPARQL_UPDATE controls both INSERT and DELETE. Thanks again, Chuck --- On Mon, 6/9/08, Ivan Mikhailov <imikhai...@openlinksw.com> wrote: > From: Ivan Mikhailov <imikhai...@openlinksw.com> > Subject: Re: [Virtuoso-users] Delete from SPARQL Endpoint > To: cborrom...@yahoo.com > Cc: virtuoso-users@lists.sourceforge.net > Date: Monday, June 9, 2008, 11:26 AM > Hello Chuck, > > Did you set write permissions for "SPARQL" > account? Say, by running > > grant SPARQL_UPDATE to "SPARQL"; > > via ISQL ? By default, SPARQL endpoint account has > read-only access to > data due to obvious security reasons. > > Best Regards, > > Ivan Mikhailov, > OpenLink Software > http://virtuoso.openlinksw.com > > > On Fri, 2008-06-06 at 14:07 -0700, Chuck Borromeo wrote: > > Hi, > > I am trying to delete a triple from my local > machine. I am running > > Virtuoso 5.0.6. I am executing the following SPARQL > statement from the > > SPARQL endpoint: > > > > delete from graph <http://xyz> > > { <testURI> <hasProperty> > <http://testnode> } > > > > I got the following error when I ran on my localhost. > It sounds like a > > permissions error: > > > > 42000 Error SR186: No permission to execute procedure > > DB.DBA.SPARQL_DELETE_DICT_CONTENT. > > > > SPARQL query: > > define sql:signal-void-variables 1 define > output:valmode "LONG" delete > > from graph <http://xyz> > > { <testURI> <hasNeuroML> > <http://testnode> } > > > > I was not able to find the Procedure > DB.DBA.SPARQL_DELETE_DICT_CONTENT > > in Conductor. How do I execute a delete through the > SPARQL endpoint? > > > > Thanks, > > Chuck > > > > > > > > > > > > > ------------------------------------------------------------------------- > > Check out the new SourceForge.net Marketplace. > > It's the best place to buy or sell services for > > just about anything Open Source. > > http://sourceforge.net/services/buy/index.php > > _______________________________________________ > > Virtuoso-users mailing list > > Virtuoso-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
