Hi Hugh,

this affect the problem using my own store in dbpedia?

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: ..."


How about the Service keyboard quering dbpedia?
Why this does not work?

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


Reply via email to