SQL Server--Permission of excute export /import Wizard

Posted by: bart30508 | in SQL Server | 11 months ago |

SQL Server--Permission of excute export /import Wizard

首先需要先確認, 安裝SQL Server的伺服器上, 有沒有安裝此套件.

權限部分, 要export/import的db_owner還不夠.

不過不是不夠, 理論上db role 只要開到read與write就ok.

因為需要其他server role.

除了sysadmin的其他都要(還沒測試到最小權限)

並且

如果有使用SSIS的話, 還需要MSDB的Write權限.

– Permission to read from the source database or file.

– Permission to write data to the destination database or file.

– To save the Integration Services package created by the wizard, the security principal requires INSERT permission on the msdb database. – If it is necessary to create a new database or table to complete the wizard, the appropriate permissions are required on the destination database instance.

-- If you want to create a new destination database or table or file, permissions sufficient to create the new database or table or file. In SQL Server 2005, this requires CREATE DATABASE or CREATE TABLE permissions.

-- If you want to save the package created by the wizard, permissions sufficient to write to the msdb database or to the file system. In Integration Services, this requires INSERT permissions on the msdb database.

-- For more information about how to manage permissions for Integration Services packages by using SQL Server Management Studio, see Integration Services Roles.

參考來源:

https://www.techveze.com/using-sql-server-import-export-wizard/ https://dba.stackexchange.com/questions/238634/permission-error-when-trying-to-import-sql https://www.sqlservercentral.com/forums/topic/permission-issue-for-excute-export-import https://solutioncenter.apexsql.com/how-to-import-and-export-sql-server-data-to-an-excel-file/

Currently unrated
 or 

Subscribe

* indicates required

Recent Posts

Archive

2022
2021

Categories

Apache 1

Data Science 2

Dbfit 1

Design Pattern 1

Devops 3

DigitalOcean 1

Django 1

English 3

Excel 5

Flask 3

Git 1

HackMD 1

Heroku 1

Html/Css 1

Linux 4

Machine Learning 2

Manufacture 1

Mezzanine 18

Oracle 1

Postgresql 7

PowerBI 4

Powershell 4

Python 21

SEO 2

SQL Server 51

SQLite 1

Windows 1

database 8

work-experience 1

其他 1

自我成長 1

資料工程 1

Tags

SEO(1) Github(2) Title Tag(2) ML(1) 李宏毅(1) SQL Server(18) Tempdb(1) SSMS(1) Windows(1) 自我成長(2) Excel(1) python Flask(1) python(5) Flask(2)

Authors

bart30508 (146)

Feeds

RSS / Atom

SQL Server--Permission of excute export /import Wizard

© COPYRIGHT 2011-2022. Max的文藝復興. ALL RIGHT RESERVED.