Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You may get permission related error messages when using SSMA for Oracle

You may get permission related error messages when using SSMA for Oracle

Symptoms

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

↑ Back to the top

Cause

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.

↑ Back to the top

Resolution

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

↑ Back to the top

Keywords: vkball, kb

↑ Back to the top

Article Info
Article ID : 2020711
Revision : 1
Created on : 1/8/2017
Published on : 3/13/2011
Exists online : False
Views : 113