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)

huangapple go评论55阅读模式
英文:

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)

问题

我试图在Virtuoso SPARQL查询编辑器上运行以下查询,但出现了以下错误:

Virtuoso 42000 Error SQ070:SECURITY: 必须具备对视图DB.DBA.SPARQL_SINV_2的SELECT权限,群组ID为108(SPARQL),用户ID为108(SPARQL)

查询:

SPARQL查询:
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 .
    }
}

能否有人帮助我解决这个问题?我对这个领域非常陌生!

英文:

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!

答案1

得分: 3

这对我有效,使用 iSQL

授权 SPARQL_LOAD_SERVICE_DATA 给 "SPARQL";
授权 SPARQL_SPONGE 给 "SPARQL";

文档链接: http://vos.openlinksw.com/owiki/wiki/VOS/VirtTipsAndTricksDiscoverSPARQFedCapabilitiesSPARQL

https://github.com/dice-group/LargeRDFBench#running-sparql-11-queries

英文:

This worked for me, using iSQL

grant SPARQL_LOAD_SERVICE_DATA to "SPARQL";
grant SPARQL_SPONGE to "SPARQL";

Documentation: http://vos.openlinksw.com/owiki/wiki/VOS/VirtTipsAndTricksDiscoverSPARQFedCapabilitiesSPARQL

and

https://github.com/dice-group/LargeRDFBench#running-sparql-11-queries

答案2

得分: 2

以下是已翻译的内容:

报告的错误是由尝试在未设置为允许此类查询的公共Virtuoso终端上运行联合SPARQL(也称为SPARQL-FED)查询引起的。

正如@AKSW所指出的,SERVICE子句无论如何都是不必要的,因为您查询中的“远程”终端与您运行主查询的终端相同。

英文:

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.

huangapple
  • 本文由 发表于 2020年1月3日 17:31:44
  • 转载请务必保留本文链接:https://go.coder-hub.com/59576044.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定