Hi Sunday, Which Virtuoso SPARQL endpoint is your application (sparqlwrapper ?) connecting to and how is user authentication be performed against it ? As looking at the error being reported the access is denied to "user 107 (SPARQL)” which is a special user SPARQL queries again the /sparql endpoint, which has no authentication enabled, are executed as. There is also a default /sparql-auth endpoint which does challenge for authentication and will then execute queries as the authenticated user. See the following documentation for more information on Virtuoso SPARQL authentication:
http://docs.openlinksw.com/virtuoso/rdfsparql.html#sparqloauthendpointauth
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 20 Mar 2016, at 01:20, Sunday Ayandokun <sunday.ayando...@gmail.com> wrote:
>
> Hello All,
>
> I did the following to set up personal graph, such that only me can access my
> graph via Sparql endpoint.
>
> After creating the user ‘sunday'
> 1. GRANT SPARQL_UPDATE TO “sunday"
> 2. DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 0);
> 3. SPARQL CREATE GRAPH <http://example.com/sunday/persons/>;
> 4. DB.DBA.RDF_GRAPH_USER_PERMS_SET('http://example.com/sunday/persons,
> ’sunday', 3);
>
> I am using this spaqrlwrapper in my application(django)
> https://github.com/RDFLib/sparqlwrapper
>
> From the error below I see it’s still using the SPAQRL user to query, but
> since I gave permission to only ‘sunday’ it will fail.
>
> How can I query the endpoint within my application via http request and
> specify the credentials of the graph owner.
> Virtuoso RDF02 Error SR619: SPARUL CLEAR GRAPH access denied: database user
> 107 (SPARQL) has no write permission on graph
> http://example.com/sunday/persons/
>
> SPARQL query:
> define sql:big-data-const 0
> #output-format:application/sparql-results+json
> CLEAR GRAPH <
> http://example.com/sunday/persons/>
>
> Thanks.
>
>
> Kind Regards.
> Sunday Ayandokun
> University of Tartu
> Tel: +37256724770
> Skype: sunday.ayandokun
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785231&iu=/4140_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785231&iu=/4140
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
