Hi Robbet,
This is a known issue with the open source builds which is scheduled to be
fixed. In the meantime you can grant the necessary privileges as follows:
grant select on "DB.DBA.SPARQL_SINV_2" to “SPARQL”;
grant execute on "DB.DBA.SPARQL_SINV_IMP" to "SPARQL";
Then the SPARQL-FED queries should start to work ...
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 Jun 2011, at 14:45, Robbet wrote:
> Hi,
>
> when using the SERVICE keyword on my local store (f.e. on dbpedia or
> linked.mdb endpoint) i got no results (and no errors).
>
> Tried the sample query from
> http://www.snee.com/bobdc.blog/2010/01/federated-sparql-queries.html
> which works on the Query Demo Page (http://www.sparql.org/query.html).
>
> Then i tried the opposite and used my localstore as SERVICE within the
> dbpedia endpoint.
> I reveived the following error:
>
> "Virtuoso 42000 Error SQ200: Must have select privileges on view
> DB.DBA.SPARQL_SINV_2"
>
> What wrong in both cases or what do i have to fix on my local config?
>
> Best regards,
>
> Robert
>
>
>
>
>
> ------------------------------------------------------------------------------
> Simplify data backup and recovery for your virtual environment with vRanger.
> Installation's a snap, and flexible recovery options mean your data is safe,
> secure and there when you need it. Discover what all the cheering's about.
> Get your free trial download today.
> http://p.sf.net/sfu/quest-dev2dev2
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
