When SSMA is used the user can get an error message saying: Failed prerequisites list:
Common requirement: Extension Pack is corrupted or You do not have permission to use it.
Incorrect privileges of the user. User doesn’t have the privilege to run the following query: SELECT * FROM sysdb.sys.schemas where name = 'ssma_syb'
Give the sufficient privileges to the user.
Depending on the operation user performing, following permissions are required:
- For most operations it is enough to give a user an access to the database and grant a role ssma_syb.
- If a user needs to perform a data migration, rights to create and start job will be needed (including CmdExec).
- If a user needs to work with tester, we highly recommend giving the user full rights on ssmatesterdb_syb database.
Article Id: KBS2SS1002
• SSMA 2005 for Sybase
• SSMA 2008 for Sybase