Hi Houda,
You are missing the following from the example in the documentation, which is
required before you can set user permissions on graphs:
-- At least some data are supposed to be confidential,
-- thus the whole storage becomes confidential.
DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 0);
-- Moreover, no one of created users have access to all
-- graphs (even for reading).
DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('Anna', 0);
The error message is rather misleading though, so will see about getting it
changed
$ /opt/virtuoso/bin/isql opluswinbuild:1111
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> DB.DBA.USER_CREATE ('Anna', 'Anna');
Done. -- 4285 msec.
SQL> DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('Anna', 1);
Done. -- 1201 msec.
SQL> DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3);
*** Error RDF99: [Virtuoso Driver][Virtuoso Server]Permissions of
unauthenticated user are broader than new permissions of user "Anna" on
specific graph <http://example.com>
at line 3 of Top-Level:
DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3)
SQL> DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 0);
Done. -- 386 msec.
SQL> DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3);
Done. -- 251 msec.
SQL>
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 3 Aug 2011, at 10:36, Houda kr wrote:
> Hi,
>
> I am trying to create a new user (Anna) in Virtuoso and specify his
> permission (read/write) on a specific graph <http://example.com> and only
> read for the rest of graphs. I follow the example provided in this link
> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFGraphsSecurity,
> and I execute the following commands :
> DB.DBA.USER_CREATE ('Anna', 'Anna');
> DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('Anna', 1);
> DB.DBA.RDF_GRAPH_USER_PERMS_SET ('http://example.com', 'Anna', 3);
>
> But, the last command generates the following error :
>
> *** Error RDF99: [Virtuoso Driver][Virtuoso Server]Permissions of
> unauthenticated user are broader than new permissions of user "Anna" on
> specific graph <http://example.com>
>
> Is there something wrong ?
>
> Thanks
> Houda
>
>
> ------------------------------------------------------------------------------
> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
> The must-attend event for mobile developers. Connect with experts.
> Get tools for creating Super Apps. See the latest technologies.
> Sessions, hands-on labs, demos & much more. Register early & save!
> http://p.sf.net/sfu/rim-blackberry-1_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
