Hi,
I've problems to setup a specific application user which is populated
during a debian apt-get install run (of the ontowiki-virtuoso LOD2
debian package).
Currently I create a user and its environment with the autoexec.sql
features (as proposed by Tim Haynes). This works nicely but I have a
concrete problem with a specific right.
Our user needs to import files from the upload directory and the
ontowiki base directory (virtuoso.ini AllowDir line is modified
correctly).
This is the autoexec.sql file currently used (found it somewhere on the web so
feel free to suggest changes ...):
USER_CREATE('ontowiki_deb', 'usepwgenhere', vector ('SQL_ENABLE',1));
GRANT SELECT ON sys_rdf_schema TO ontowiki_deb;
GRANT execute ON rdfs_rule_set TO ontowiki_deb;
USER_GRANT_ROLE('ontowiki_deb', 'SPARQL_SELECT', 0);
USER_GRANT_ROLE('ontowiki_deb', 'SPARQL_UPDATE', 0);
With this, we get the following virtuoso response:
SR159: Function file_to_string_session restricted to dba group. () in query:
CALL DB.DBA.RDF_LOAD_RDFXML(
FILE_TO_STRING_OUTPUT(
'/usr/share/php/liberfurt-php/Erfurt/include/SysOntLocal.rdf'),
'http://localhost/OntoWiki/Config/',
'http://localhost/OntoWiki/Config/')
and an additional
USER_GRANT_ROLE('ontowiki_deb', 'administrators', 0);
give me this error
Message: U0013: The object "ontowiki_deb" already have role
"administrators" assigned
any ideas?
Best regards
Sebastian Tramp
--
Sebastian Tramp - Department of Computer Science; University of Leipzig
WebID: http://sebastian.tramp.name Tel. (Fax): +49 341 97 323-66 (-29)
