15.142 SEM_APIS.REVOKE_NETWORK_SHARING_PRIVS

Format

SEM_APIS.REVOKE_NETWORK_SHARING_PRIVS(
     network_owner  IN VARCHAR2, 
     options        IN VARCHAR2 default NULL);

Description

Note:

You can skip the REVOKE_NETWORK_SHARING_PRIVS procedure if your Oracle Database version is 23.4.

Revokes from a database user the privileges required for sharing, with other database users, any schema-private networks owned (currently or in the future) by the database user

Parameters

network_owner

Owner of the network. (Cannot be MDSYS.)

options

(Reserved for future use)

Usage Notes

You must have DBA privileges to call this procedure.

If the database user owns at least one schema-private network that has sharing enabled, an exception will be raised. (The user must first disable sharing of any such networks.)

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

Examples

The following example revokes from database user scott the privileges for sharing any schema-private networks that this user owns or will own.

EXECUTE SEM_APIS.REVOKE_NETWORK_SHARING_PRIVS('scott');