Moving databases -> user table oddity -> need help
We are migrating from a Oracle 9i database to an Oracle 10g database.
The majority of the data appears to have moved successfully, but we have a user oddity.
In the site admin\site projects tab, the "project users" sub-tab for some projects is blank, whereas other projects have their correct user lists.
In addition to this, the "users" table in the project drill-down is populated with the correct users.
In my investigations, I have been able to discern that there are site admin tables governing user project permissions and local project user table stored in the projects themselves.
My assumption is that the projects user table is populated correctly, but the site admin table is not.
Is this a correct assumption? If so, what table do I need to re-pull from our original database to re-synchronize the original project user list in the site admin db?
Thanks in advance!