英文:
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论