With the reference to above link, we do understand the SSMA needs some additional permissions. Its mentioned as
To obtain metadata for objects in other schemas and then convert objects in those schemas, your account must have the following permissions on the source database.
CREATE ANY PROCEDURE
EXECUTE ANY PROCEDURE
SELECT ANY TABLE
SELECT ANY SEQUENCE
CREATE ANY TYPE
CREATE ANY TRIGGER
We are using the SSMA for migration.
I am having read only oracle user and I want to access schemas/database objects created by other users via SSMA.
Can anyone please help me to UNDERSTAND why SSMA needs CREATE & EXECUTE permissions?
Is there any other alternative available to use SSMA with READ ONLY access oracle user?