Nathan wrote:
Hi,
extremely urgent (apologies) I can't get insert to work over SPARQL at
all; I've given SPARQL user SPARQL_UPDATE role; but error is:
42000 Error SR186: No permission to execute procedure
DB.DBA.SPARQL_INSERT_DICT_CONTENT.
tried the grant way and getting errors all over:
SQL> GRANT SELECT ON DB.DBA.SPARQL_DELETE_DICT_CONTENT TO "SPARQL";
*** Error 42S02: [Virtuoso Driver][Virtuoso Server]SR136: Bad table name
in GRANT / REVOKE DB.DBA.SPARQL_DELETE_DICT_CONTENT.
at line 1 of Top-Level:
GRANT SELECT ON DB.DBA.SPARQL_DELETE_DICT_CONTENT TO "SPARQL"
SQL> GRANT SELECT ON DB.DBA.SPARQL_INSERT_DICT_CONTENT TO "SPARQL";
*** Error 42S02: [Virtuoso Driver][Virtuoso Server]SR136: Bad table name
in GRANT / REVOKE DB.DBA.SPARQL_INSERT_DICT_CONTENT.
at line 2 of Top-Level:
GRANT SELECT ON DB.DBA.SPARQL_INSERT_DICT_CONTENT TO "SPARQL"
any quick ways to get this working without rebuilding; I've onyl got a
few hours left before live and need to get some triples saving and
deleting via sparql.
maybe i can drop and recreate the procedures if you have the code for them??
regards,
nathan
------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Did this fail:
GRANT EXECUTE on DB.DBA.SPARQL_DELETE_DICT_CONTENT TO "SPARQL";
--
Regards,
Kingsley Idehen Weblog: http://www.openlinksw.com/blog/~kidehen
President & CEO
OpenLink Software Web: http://www.openlinksw.com
