Robbet, On 5 Jun 2011, at 11:52, Robbet wrote:
> Hi Hugh, > > this affect the problem using my own store in dbpedia? [Hugh] You run the grant statements below against you local Virtuoso instance where you are attempting to run the SPARQL-FED query from and gives the error you originally reported. > > When i try to grant the second line i receive: > > "bad table name in GRANT / REVOKE DB.DBA.SPARQL_SINV_IMP_2. at line 5 of > TOP-Level: ...” [Hugh] I just tested this against a new Windows 64bit VOS 6.1.3 instance and both queries worked for me and then enabled me to run a SPARQL-FED query. > > > How about the Service keyboard quering dbpedia? > Why this does not work? [Hugh] Not sure what you mean, it fails because of the error you originally reported ??? Regards Hugh > > Best regards, > > Robertv > > On 05.06.2011 02:04, Hugh Williams wrote: >> 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 >> >> ------------------------------------------------------------------------------ >> 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 >> > > ------------------------------------------------------------------------------ > 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
