A window will display when the user is trying to use SSMA connect to source Oracle database to load the Oracle metadata, saying that user does not have permissions: SELECT ANY TABLE, CREATE ANY PROCEDURE, SELECT ANY SEQUENCE, CREATE ANY TYPE,CREATE ANY TRIGGER
The above window will display when the user does not have one of these permissions:
"SELECT ANY TABLE",
"CREATE ANY PROCEDURE",
"SELECT ANY SEQUENCE",
"CREATE ANY TYPE",
"CREATE ANY TRIGGER
The account that is used to connect to the Oracle database must have at least CONNECT permissions. This enables SSMA to obtain metadata from schemas owned by the connecting user.
To obtain metadata for objects in other schemas and then convert objects in those schemas, the account must have the following permissions: CREATE ANY PROCEDURE, EXECUTE ANY PROCEDURE, SELECT ANY TABLE, SELECT ANY SEQUENCE, CREATE ANY TYPE, CREATE ANY TRIGGER
Yes, you can ignore the warnings and click on continue so that SSMA will get the metadata from the schemas owned by the user. You can proceed with schema migration and data migration.
SSMA won't write anything to the source (oracle) database when you run schema migration and data migration.
Article Id: KBO2SS1002
SSMA 2005 for Oracle
SSMA 2008 for Oracle