Data Dictionary Views, 8 of 112

ALL_REPCAT_USER_AUTHORIZATIONS

Lists the authorized users for private deployment templates accessible to the current user. Users listed in this view have the ability to instantiate the specified template. Users not contained in this view cannot instantiate the deployment template.

Related views:

DBA_REPCAT_USER_AUTHORIZATIONS lists the authorized users for all the private deployment templates in the database.

USER_REPCAT_USER_AUTHORIZATIONS lists the authorized users for private deployment templates owned by the current user.

Column Datatype NULL Description

REFRESH_TEMPLATE_NAME

VARCHAR2(30)

NOT NULL

Name of the deployment template that a user has been authorized to instantiate.

OWNER

VARCHAR2(30)

NOT NULL

Name of the owner of the deployment template.

REFRESH_GROUP_NAME

VARCHAR2(30)

NOT NULL

Name of the refresh group to which template objects are added during the instantiation process.

TEMPLATE_COMMENT

VARCHAR2(2000)

User specified comment.

PUBLIC_TEMPLATE

VARCHAR2(1)

If Y then the deployment template is public.
If N then the deployment template is private.

USER_NAME

VARCHAR2(30)

NOT NULL

Name of the user who has been authorized to instantiate the deployment template.

Column	Datatype	NULL	Description
`REFRESH_TEMPLATE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the deployment template that a user has been authorized to instantiate.
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Name of the owner of the deployment template.
`REFRESH_GROUP_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the refresh group to which template objects are added during the instantiation process.
`TEMPLATE_COMMENT`	`VARCHAR2(2000)`		User specified comment.
`PUBLIC_TEMPLATE`	`VARCHAR2(1)`		If Y then the deployment template is public. If N then the deployment template is private.
`USER_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the user who has been authorized to instantiate the deployment template.