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 SPARQL

• SELECT, READ: Retrieve model content using SQL. The source for the content is the RDFT_<model> view in the network owner’s schema or the view name, if any, specified for the user_view parameter.

• INSERT, UPDATE, DELETE: Perform SPARQL Update (DML) operations on the model or SQL DML operations. For SQL DML, the target object is the RDFT_<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 using sem_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 using sem_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 specified model_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: network_owner and network_name Parameters.)

network_name

Name of the semantic network. (See Table: network_owner and network_name Parameters.)

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: Using an RDF Graph for Journal Article Information.)

EXECUTE SEM_APIS.GRANT_MODEL_ACCESS_PRIV('articles', 'USER1', 'QUERY', network_owner=>'RDFUSER', network_name=>'NET1');