About the ORCL_GLOBAL_USR_MIGRATION_DATA Table

This is the interface table which is populated with information about the migrating users during Phase One of the bulk user migration process. The information that populates this table is pulled from the database and checked against existing entries in the directory. If there is corresponding information in the directory, then that is marked in the table for that user. After enterprise user administrators verify the information in this table, changes are made to the directory and the database in Phase Two.

Note:

The ORCL_GLOBAL_USR_MIGRATION_DATA interface table contains very sensitive information. Access to it should be tightly controlled using database privileges.

The table columns are listed in Table A-1.

Table A-1 ORCL_GLOBAL_USR_MIGRATION_DATA Table Schema

Column Name	Data Type	Null	Description
`USERNAME` (Primary Key)	VARCHAR2(30)	NOT NULL	Database user name
`OLD_SCHEMA_TYPE`	VARCHAR2(10)	-	Old schema type in the database before migration
`PASSWORD_VERIFIER`	VARCHAR2(30)	-	Not used
`USERDN`	VARCHAR2(4000)	-	Distinguished Name (DN) of the user in the directory (new or existing)
`USERDN_EXIST_FLAG`	CHAR(1)	-	Flag indicating whether the DN already exists in the directory
`SHARED_SCHEMA`	VARCHAR2(30)	-	Shared schema name, if users are to be mapped to a shared schema during phase two
`MAPPING_TYPE`	VARCHAR2(10)	-	Mapping type (database or domain)
`MAPPING_LEVEL`	VARCHAR2(10)	-	Mapping level (entry or subtree)
`CASCADE_FLAG`	CHAR(1)	-	Cascade flag used when dropping a user (for shared schema mapping only)
`DBPASSWORD_EXIST_FLAG`	CHAR(1)	-	Flag indicating whether the database password verifier already exists in the directory for this user
`DBPASSWORD`	VARCHAR2(30)	-	Randomly generated database password verifiers to be stored in the directory
`DIRPASSWORD`	VARCHAR2(30)	-	Randomly generated directory password for new entries
`PHASE_COMPLETED`	VARCHAR2(10)	-	Information about the phase that has been completed successfully
`NEEDS_ATTENTION_FLAG`	CHAR(1)	-	Flag indicating whether the row contains abnormalities that require administrator attention
`ATTENTION_DESCRIPTION`	VARCHAR2(100)	-	Textual hint for the administrator if the attention flag is set
`KERBEROS_PNAME`	VARCHAR2(30)	-	Kerberos Principal Name for external kerberos users