Hi Yan, How are your SPARQL update operations being performed ie are you using SPARQL 1.1 update queries or the Virtuoso RDF Bulk loader ?
The error seems to imply that the RDF data load is occurring on multiple threads whose user id does not have the sparql_update rights … If you run the trace_on() function from isql to enable extra debug logging to the virtuoso.log file, does this show any additional information in the log as why the error is occurring ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers > On 4 Oct 2016, at 09:07, mai <golden...@hotmail.com> wrote: > > Hi there, > > I need to grant permissions, load RDF data and insert, modify and delete some > of the triples, in script (not interactively through Virtuoso Conductor). > I grant permissions for Virtuoso version 7.1.0.3207, and it worked fine: > isql VERBOSE=$VERB ERRORS=stdout ECHO=$VERB "exec=grant execute on > DB.DBA.SPARQL_MODIFY_BY_DICT_CONTENTS to \"SPARQL\";" > > isql VERBOSE=$VERB ERRORS=stdout ECHO=$VERB "exec=grant execute on > DB.DBA.SPARQL_MODIFY_BY_DICT_CONTENTS to \"SPARQL_UPDATE\";" > > isql VERBOSE=$VERB ERRORS=stdout ECHO=$VERB "exec=grant execute on > DB.DBA.SPARQL_DELETE_DICT_CONTENT to \"SPARQL\";" > > isql VERBOSE=$VERB ERRORS=stdout ECHO=$VERB "exec=grant execute on > DB.DBA.SPARQL_DELETE_DICT_CONTENT to \"SPARQL_UPDATE\";" > > isql VERBOSE=$VERB ERRORS=stdout ECHO=$VERB "exec=grant execute on > DB.DBA.SPARQL_INSERT_DICT_CONTENT to \"SPARQL\";" > > isql VERBOSE=$VERB ERRORS=stdout ECHO=$VERB "exec=grant execute on > DB.DBA.SPARQL_INSERT_DICT_CONTENT to \"SPARQL_UPDATE\";" > > isql VERBOSE=$VERB ERRORS=stdout ECHO=$VERB "exec=grant execute on > DB.DBA.L_O_LOOK to \"SPARQL\";" > > isql VERBOSE=$VERB ERRORS=stdout ECHO=$VERB "exec=grant execute on > DB.DBA.L_O_LOOK to \"SPARQL_UPDATE\";" > But It seems not working for the new version 7.2.4.2.3217. I got error > message by deleting triples. > Virtuoso 42000 Error CL...:SECURITY: No SPARQL_UPDATE permission to use RDF > loader > I tried > exec=grant SPARQL_UPDATE to \"SPARQL\"; > But it did not help. > > How can I solve this problem? please help. > Thanks, Yan > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org <http://slashdot.org/>! > http://sdm.link/slashdot_______________________________________________ > <http://sdm.link/slashdot_______________________________________________> > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > <mailto:Virtuoso-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
