When you try to try to connect to your source database on your Oracle server to load Oracle's metadata using SQL Server Migration Assistant for Oracle, you may get an error message that indicates that you do not have the following privileges on the Oracle’s source database.
SELECT ANY TABLE, CREATE ANY PROCEDURE, SELECT ANY SEQUENCE, CREATE ANY TYPE,CREATE ANY TRIGGER
The error occurs when the user does not have one or more of the privileges mentioned in the error message on the Oracle’s source database. The account that is used to connect to the Oracle database must at least have CONNECT permissions. This enables SSMA to obtain metadata from schemas owned by the connecting user.
If you are just trying to migrate only the source databases that are owned by you or have permissions to, you can ignore the warnings and click the CONTINUE button to enable SSMA to retrieve the metadata from the respective schemas.
To obtain metadata for objects in other schemas and then convert objects in those schemas, your account must have the following privileges on the source database:
CREATE ANY PROCEDURE
EXECUTE ANY PROCEDURE
SELECT ANY TABLE
SELECT ANY SEQUENCE
CREATE ANY TYPE
CREATE ANY TRIGGER
Example 1: (not work)
SQL:> GRANT CREATE ANY PROCEDURE, EXECUTE ANY PROCEDURE, SELECT ANY TABLE, SELECT ANY SEQUENCE
, CREATE ANY TYPE, CREATE ANY TRIGGER TO SCOTT;
Example 2:
SQL:> Grant DBA to scott;
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See
Terms of Use for other considerations.
Article ID: 2020711 - Last Review: October 4, 2010 - Revision: 1.0
APPLIES TO
- Microsoft SQL Server Migration Assistant 2005 for Oracle v4.0
- Microsoft SQL Server Migration Assistant 2008 for Oracle v4.0
No comments:
Post a Comment