15.139 SEM_APIS.REVOKE_MODEL_ACCESS_PRIV
Format
SEM_APIS.REVOKE_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.REVOKE_RDF_GRAPH_ACCESS_PRIV subprogram instead.Description
Revokes 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 revoked 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
This does not affect the recipient's query-only or full access to the semantic network (which guarantees access to dictionary tables, but not individual models). This operation revokes access to the specified model only.
Examples
The following example revokes privilege from database user USER1
for use of 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.REVOKE_MODEL_ACCESS_PRIV('articles', 'USER1', 'QUERY', network_owner=>'RDFUSER', network_name=>'NET1');
Parent topic: SEM_APIS Package Subprograms