Microsoft SQL Server Script Sources > Before you begin > Verify permissions

Verify permissions

To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.

Permissions for metadata extraction

To extract Microsoft SQL Server Script metadata, you need account access and permissions to the Microsoft SQL Server Script catalog source and the Microsoft SQL Server source system.

Verify that the administrator has the following permissions:

•Read permission to access the folder containing scripts.
•Permissions to configure the Microsoft SQL Server connection:

- select on sys.all_columns
- select on sys.all_objects
- select on sys.all_parameters
- select on sys.database_principals
- select on sys.databases
- select on sys.foreign_key_columns
- select on sys.indexes
- select on sys.index_columns
- select on sys.partitions
- select on sys.schemas
- select on sys.sql_modules
- select on sys.synonyms
- select on sys.types
- select on sys.tables
- select on sys.table_types