Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

DROP_USER_AUTHORIZATION Procedure

This procedure removes a user authorization entry from the DBA_REPCAT_USER_AUTHORIZATIONS view. This procedure is used when removing a user's template authorization. If a user's authorization is removed, then the user is no longer able to instantiate the target deployment template.

See Also:

"DROP_ALL_USER_AUTHORIZATIONS Procedure"

Syntax

DBMS_REPCAT_RGT.DROP_USER_AUTHORIZATION (
   refresh_template_name   IN   VARCHAR2,
   user_name               IN   VARCHAR2);

Parameters

Table 21-56 DROP_USER_AUTHORIZATION Procedure Parameters  
Parameter Description
refresh_template_name

Name of the deployment template from which the user's authorization is being removed.

user_name

Name of the user whose authorization is being removed.

Exceptions

Table 21-57 DROP_USER_AUTHORIZATION Procedure Exceptions  
Exception Description
miss_user

Specified user name is invalid or does not exist.

miss_user_authorization

Specified user and deployment template combination does not exist. Query the DBA_REPCAT_USER_AUTHORIZATIONS view to see a list of user/deployment template authorizations.

miss_refresh_template

Specified deployment template name is invalid or does not exist.