In Oracle, the static dictionary view USER_REPCAT_USER_AUTHORIZATIONS displays the users who are authorized for private deployment templates, which are owned by the current user. These users are capable of instantiating the specified template. The structure of the definition is shown below.
REFRESH_TEMPLATE_NAME [VARCHAR2(30)] - Deployment template name to be instantiated
OWNER [VARCHAR2(30)] - Deployment template owner
REFRESH_GROUP_NAME [VARCHAR2(30)] - Refresh group associated during the instantiation process.
TEMPLATE_COMMENT [VARCHAR2(2000)] - User comments
PUBLIC_TEMPLATE [VARCHAR2(1)] - Determines whether the deployment template is public or private
USER_NAME [VARCHAR2(30)] - Authorized user to instantiate the deployment template