15.141 SEM_APIS.REVOKE_NETWORK_ACCESS_PRIVS

Format

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

Description

Revokes access privileges from 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) from which to revoke access privileges to the network.

options

String specifying options for access using the form OPTION_NAME=option_value.

If CASCADE=T is specified, any RDF objects owned by the database user will be dropped as part of this operation.

Usage Notes

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

If the database user (network_user) owns any RDF objects in the schema-private network and if CASCADE=T is not specified, an error will be raised.

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

Examples

The following example revokes full access on the mynet1 network owned by scott from rdfuser1.

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