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

CREATE_USER_AUTHORIZATION Function

This function authorizes specific users to instantiate private deployment templates. Users not authorized for a private deployment template are not able to instantiate the private template. This function adds a row to the DBA_REPCAT_USER_AUTHORIZATIONS view.

Before you authorize a user, verify that the user exists at the master site where the user will instantiate the deployment template. The number returned by this function is used internally by Oracle to manage deployment templates.

Syntax

DBMS_REPCAT_RGT.CREATE_USER_AUTHORIZATION (
   user_name               IN   VARCHAR2, 
   refresh_template_name   IN   VARCHAR2)
   return NUMBER;

Parameters

Table 21-30 CREATE_USER_AUTHORIZATION Function Parameters  
Parameter Description
user_name

Name of the user that you want to authorize to instantiate the specified template. Specify multiple users by separating user names with a comma (for example, 'john, mike, bob')

refresh_template_name

Name of the template that you want to authorize the specified user to instantiate.

Exceptions

Table 21-31 CREATE_USER_AUTHORIZATION Function Exceptions  
Exception Description
miss_user

User name supplied is invalid or does not exist.

miss_refresh_template

Refresh template name supplied is invalid or does not exist.

dupl_user_authorization

An authorization has already been created for the specified user and deployment template. See the ALL_REPCAT_USER_AUTHORIZATIONS view for a listing of template authorizations.

Returns

Table 21-32 CREATE_USER_AUTHORIZATION Function Returns
Return Value Description

<system-generated number>

System-generated number used internally by Oracle.