Jason Kolb wrote:
Hi,
I'm trying to clear a graph by running a SPARQL query like this from
the conductor:
CLEAR GRAPH <http://test/graph>
When I try this, I get this error:
42000 Error SR186: No permission to execute procedure
DB.DBA.SPARUL_CLEAR.
I thought I'd be slick and just grant all permissions to dba (who I'm
logged in as) with the following statement:
GRANT ALL PRIVILEGES TO dba;
I executed this via the Interactve SQL tab in Conductor and from isql
at the command line. I also tried granting the specified permission
by name. Both run fine, but seems to change nothing.
Any idea what I can do to clear the graph?
Thanks,
Jason
Jason,
You need to explicitly assign SPARQL_UPDATE role to the relevant
account. Since this is your personal instance, assign to the 'dba' user.
Use the "User Accounts" tab in the Conductor.
Kingsley
------------------------------------------------------------------------
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
------------------------------------------------------------------------
_______________________________________________
Virtuoso-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
--
Regards,
Kingsley Idehen Weblog: http://www.openlinksw.com/blog/~kidehen
President & CEO
OpenLink Software Web: http://www.openlinksw.com
