Hi Aldo, You simply grant the SPARQL_UPDATE role to the SPARQL user the endpoint runs as:
/opt/virtuoso/bin/isql 1111 Connected to OpenLink Virtuoso Driver: 06.01.3128 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (Virtuoso), version 0.9849b. Type HELP; for help and EXIT; to exit. SQL> grant SPARQL_UPDATE to "SPARQL"; Done. -- 4 msec. SQL> This worked for me on an empty database before running the grant I got the "42000 Error SR186: No permission to execute procedure DB.DBA.SPARQL_INSERT_DICT_CONTENT" error trying to insert data via the sparql endpoint, after works the insert worked without have to restart the server or anything. The initial issue you report is in the conductor and the way or context it is attempting to assign this role I think ... 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 22 Oct 2010, at 01:25, Aldo Bucchi wrote: > 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/ > > ------------------------------------------------------------------------------ > Nokia and AT&T present the 2010 Calling All Innovators-North America contest > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > _______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
