Hi Hugh, On Mon, Oct 18, 2010 at 7:20 AM, Hugh Williams <[email protected]> wrote: > Hi Aldo, > > I have been able to recreate the problem, which has actually been reported be > before I believe, well the inability to perform SPARUL operations after > adding the SPARQL_UPDATE role to the SPARQL user that is, resulting in the > following error which I assume is what you saw also: > > 42000 Error SR186: No permission to execute procedure > DB.DBA.SPARQL_INSERT_DICT_CONTENT. > > for which we told such users to manually grant the permissions as follows: > > grant execute on SPARQL_INSERT_DICT_CONTENT to "SPARQL" > grant execute on SPARQL_INSERT_DICT_CONTENT to SPARQL_UPDATE > > Not realising a server restart would enable the updates to be performed, even > if it should not be required, so we shall fix it ...
Thanks. One question. I have to enable SPARUL via the /sparql endpoint "programatically" via isql as I don't have access to /conductor ( firewall ). What's the official set of statements to achieve this? taking into account the aforementioned bug. Thanks! A > > 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 18 Oct 2010, at 01:30, Aldo Bucchi wrote: > >> Hi Hugh, >> >> On Sun, Oct 17, 2010 at 8:10 PM, Hugh Williams <[email protected]> >> wrote: >>> Hi Aldo, >>> >>> Can you please confirm which Virtuoso product open source or commercial and >>> Virtuoso Server and Conductor versions being used ? >> >> Sure. >> >> Virtuoso: >> Version 06.01.3127-pthreads for Darwin as of Aug 29 2010 >> >> Conductor: >> 1.00.7817/ 2010-08-29 >> >> I gave SPARQL a SPARQL-UPDATE and issuing a SPARQL MODIFY against the >> endpoint only worked after a server restart. >> I don't have the exact error as this was buried deep down a stack but >> I remember it was complaining about not having permission to execute a >> procedure. And I am 90% certain that the procedure had the words >> UPDATE, RDF and DICT. >> >> That's a fuzzy query against my memory :) >> >> Regards, >> A >> >> >>> >>> I have tested with: >>> >>> open source : Virtuoso Version: 06.01.3127 Build: Jul 9 2010, conductor >>> 1.00.7817/ 2010-07-09 >>> >>> commercial: Virtuoso Version: 06.02.3128 Build: Sep 15 2010, >>> conductor dav 1.00.7839/ 2010-09-15 >>> >>> 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 15 Oct 2010, at 20:37, Aldo Bucchi wrote: >>> >>>> -- >>>> Aldo Bucchi >>>> @aldonline >>>> skype:aldo.bucchi >>>> http://aldobucchi.com/ >>>> >>>> ------------------------------------------------------------------------------ >>>> Download new Adobe(R) Flash(R) Builder(TM) 4 >>>> The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly >>>> Flex(R) Builder(TM)) enable the development of rich applications that run >>>> across multiple browsers and platforms. Download your free trials today! >>>> http://p.sf.net/sfu/adobe-dev2dev >>>> _______________________________________________ >>>> Virtuoso-users mailing list >>>> [email protected] >>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >>> >>> >> >> >> >> -- >> Aldo Bucchi >> @aldonline >> skype:aldo.bucchi >> http://aldobucchi.com/ >> >> ------------------------------------------------------------------------------ >> Download new Adobe(R) Flash(R) Builder(TM) 4 >> The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly >> Flex(R) Builder(TM)) enable the development of rich applications that run >> across multiple browsers and platforms. Download your free trials today! >> http://p.sf.net/sfu/adobe-dev2dev >> _______________________________________________ >> Virtuoso-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > -- Aldo Bucchi @aldonline skype:aldo.bucchi http://aldobucchi.com/
