Common Requirement: User does not have required permissions

Symptom

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

Cause

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

Resolution

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.

More Information

Article Id: KBO2SS1002

Applies to

SSMA 2005 for Oracle

SSMA 2008 for Oracle