15.111 SEM_APIS.GRANT_MODEL_ACCESS_PRIV
Format
SEM_APIS.GRANT_MODEL_ACCESS_PRIV( model_name IN VARCHAR2, user_name IN VARCHAR2, privilege IN VARCHAR2, user_view IN VARCHAR2 DEFAULT NULL, options IN VARCHAR2 DEFAULT NULL, network_owner IN VARCHAR2 DEFAULT NULL, network_name IN VARCHAR2 DEFAULT NULL);
Note:
This subprogram will be deprecated in a future release. It is recommended that you use the SEM_APIS.GRANT_RDF_GRAPH_ACCESS_PRIV subprogram instead.Description
Grants access privilege on a model or entailment.
Parameters
- model_name
-
Name of the model.
- user_name
-
Database user that is recipient of this privilege.
- privilege
-
Specifies the type of privilege that is granted. Currently allowed values include the following:
QUERY
: Query the model using SPARQLSELECT
,READ
: Retrieve model content using SQL. The source for the content is theRDFT_<model>
view in the network owner's schema or the view name, if any, specified for theuser_view
parameter.INSERT
,UPDATE
,DELETE
: Perform SPARQL Update (DML) operations on the model or SQL DML operations. For SQL DML, the target object is theRDFT_<model>
view in the network owner's schema.
Note:
QUERY
is the only valid choice if the model is not a regular model (that is, not created usingsem_apis.create_sem_model
). - user_view
-
Applicable to schema-private network only. If a view was created on the
RDFT_<model>
view at model creation time usingsem_apis.create_sem_model
or later, privilege is granted on that view. - options
-
If user specifies the word
ENTAILMENT
as part of the string value, then the specifiedmodel_name
is taken as the name of an entailment (rules index). (Additional words or phrases may be allowed in future.) - network_owner
-
Owner of the semantic network. (See Table 1-2.)
- network_name
-
Name of the semantic network. (See Table 1-2.)
Usage Notes
The recipient must already have query-only or full access to the semantic network (which guarantees access to dictionary tables, but not individual models). This operation grants access to the specified model.
Examples
The following example grants privilege to database user USER1
to use SPARQL query against a semantic technology model named articles
in the schema-private network NET1
owned by database user RDFUSER
. (This example refers to the model described in Example 1-129.)
EXECUTE SEM_APIS.GRANT_MODEL_ACCESS_PRIV('articles', 'USER1', 'QUERY', network_owner=>'RDFUSER', network_name=>'NET1');
Parent topic: SEM_APIS Package Subprograms