Search code examples
sparqldbpediavirtuoso

Virtuoso 42000 Error SQ070:SECURITY: Must have SELECT privileges on view DB.DBA.SPARQL_SINV_2 for group ID 108 (SPARQL), user ID 108 (SPARQL)

I am trying to run the following query on Virtuoso SPARQL Query Editor and I get this error:

Virtuoso 42000 Error SQ070:SECURITY: Must have SELECT privileges on view DB.DBA.SPARQL_SINV_2 for group ID 108 (SPARQL), user ID 108 (SPARQL)

Query:

SPARQL query:
define sql:big-data-const 0 
#output-format:text/html
define sql:signal-unconnected-variables 1 define sql:signal-void-variables 1 define input:default-graph-uri <http://dbpedia.org>
PREFIX dbr: <http://dbpedia.org/resource/>
PREFIX dbp: <http://dbpedia.org/property/>
SELECT ?country ?pop
WHERE {
    VALUES ?country {
        dbr:Scotland
        dbr:England
        dbr:Wales
        dbr:Northern_Ireland
        dbr:Ireland
    }

    SERVICE <http://dbpedia.org/sparql> {
        ?country dbp:populationCensus ?pop .
    }
}

Can someone please help me sort this out, I am very new to this field!

Solution

  • The reported error resulted from attempting to run a Federated SPARQL (a/k/a SPARQL-FED) query — that is, a query using a SERVICE clause — on a public Virtuoso endpoint which is not set up to permit such queries.

    As @AKSW noted, the SERVICE clause is unnecessary anyway, because the "remote" endpoint in your query is the same endpoint on which you're running the main query.