Kurt,
On 3 Feb 2009, at 12:53, Kurt J wrote:
sounds very useful. however it doesn't seem to be working :( after
adding SPARQL_UPDATE to SPARQL in the conductor UI i get this from the
endpoint:
42000 Error SR186: No permission to execute procedure
DB.DBA.SPARQL_INSERT_DICT_CONTENT.
SPARQL query:
define sql:signal-void-variables 1 insert in graph
<http://dbtune.org/cmn/resource>
{<http://dbtune.org/cmn/resource/kurtjx>
<http://purl.org/onotology/classicalmusicnav#influencedBy>
<http://dbtune.org/cmn/resource/WAGN>}
any idea what i'm missing?
[Hugh] You need to run the following from isql:
grant execute on SPARQL_INSERT_DICT_CONTENT to "SPARQL"
grant execute on SPARQL_INSERT_DICT_CONTENT to SPARQL_UPDATE
This worked for me ...
I need to now find out why this was not done by default as I think it
should have ...
Regards
Hugh
cheers,
kurt j
On Tue, Feb 3, 2009 at 12:27 PM, Hugh Williams
<hwilli...@openlinksw.com> wrote:
Kurt,
On 3 Feb 2009, at 11:19, Kurt J wrote:
Do you have the SPARQL_SPONGE role enabled for SQL USER
"SPARQL" ? This
is
ROLE isn't granted by default for security reasons.
under System Admin -> User Accounts -> SPARQL -> Account Roles ->
Selected
SPARQL_SELECT
SPARQL_SPONGE
sort of unrelated question, adding the role SPARQL_UPDATE to SPARQL
would allow _anyone_ to execute an update command thru the sparql
interface?
[Hugh] Yes, it would, which is why we have the SPARQL_SPONGE role
to allow
sponger only operations to be able to update, keeping the SPARQL
endpoint
secure unless you specifically grant the SPARQL_UPDATE role to it.
Regards
Hugh
-kurt
----------------------------------------------------------------------
--------
Create and Deploy Rich Internet Apps outside the browser with Adobe
(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills
and code to
build responsive, highly engaging applications that combine the
power of local
resources and data with the reach of the web. Download the Adobe
AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/
adobe-com
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
