DB.DBA.RDF_GRAPH_USER_PERMS_SET — Sets permissions of an the user on a graph.


DB.DBA.RDF_GRAPH_USER_PERMS_SET ( in graph_iri varchar ,
  in uname varchar ,
  in perms integer );


sets permissions of the user named uname on graph specified by graph_iri to the value specified by perms.



Graph IRI.


User name.


If perms is null then the function acts as DB.DBA.RDF_GRAPH_USER_PERMS_DEL (graph_iri, uname);

If perms is not null (hence an integer) then the specified user should be an active SQL user or "nobody".

Four sorts of access are specified by four bits of an integer "permission bit-mask", plain old UNIX style:

  • Bit 1 permits read access.

  • Bit 2 permits write access via SPARUL and it's basically useless without bit 1 set.

  • Bit 4 permits write access via "RDF sponge" methods and it's basically useless without bits 1 and 2 set.

  • Bit 8 allows to obtain list of members of graph group; an IRI can be used as graph IRI and as graph group IRI at the same time so bit 8 can be freely combined with any of bits 1, 2 or 4.

For more details see our documentation section "Understanding Default Permissions"


Example 24.276. Example