Hi Nathan, Try executing the following from isql as the "dba" user:
grant execute on SPARQL_INSERT_DICT_CONTENT to "SPARQL" grant execute on SPARQL_INSERT_DICT_CONTENT to SPARQL_UPDATE 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 8 Dec 2009, at 21:47, 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
