15.113 SEM_APIS.GRANT_NETWORK_ACCESS_PRIVS

Format

SEM_APIS.GRANT_NETWORK_ACCESS_PRIVS(
     network_owner  IN VARCHAR2, 
     network_name   IN VARCHAR2, 
     network_user   IN VARCHAR2, 
     options        IN VARCHAR2 default NULL);

Description

Grants query-only or full access privileges to a database user other than the owner of a schema-private RDF network.

Parameters

network_owner

Owner of the network. (Cannot be MDSYS.)

network_name

Name of the network. (Must be a schema-private network.)

network_user

Database user (other than the network owner) to which to grant access privileges to the network.

options

String specifying options for access using the form OPTION_NAME=option_value. By default, full access privileges are given; but to give query-only access, specify QUERY_ONLY=T for the option value.

Usage Notes

You must have DBA privileges or be the owner of the specified network to call this procedure.

For information about RDF network types and options, see RDF Networks.

Examples

The following example grants full access on the mynet1 network owned by scott to rdfuser1.

EXECUTE SEM_APIS.GRANT_NETWORK_ACCESS_PRIVS('scott','mynet1','rdfuser1');

The following example grants query-only access on the mynet1 network owned by scott to rdfuser2.

EXECUTE SEM_APIS.GRANT_NETWORK_ACCESS_PRIVS('scott','mynet1','rdfuser2', options=>' QUERY_ONLY=T ');