Chuck Borromeo wrote:
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
Chuck,
This is an old snafu (in a nutshell).
The new release Virtuoso has a specific Update Role that is decoupled
from our controlled Sponger Crawling and caching functionality. You see,
with the current cut you have to take away SPARQL_UPDATE away from user
SPARQL and then assign this to a secure User or Role. Once assigned you
can then create a different SPARQL endpoint (for controlled access) that
is then associated with the secure User :-)
I hope this clears matters?
Hugh: We should have a little document that covers the creation of
custom SPARQL endpoints irrespective, as this is highly valuable
information.
Kingsley
--- 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
-------------------------------------------------------------------------
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
--
Regards,
Kingsley Idehen Weblog: http://www.openlinksw.com/blog/~kidehen
President & CEO
OpenLink Software Web: http://www.openlinksw.com
