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 ...
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
