<div>
Section 2 from &nbsp;( What permissions do I need to run the wizard? ) <br />
<br />
<a href="https://msdn.microsoft.com/en-us/library/ms141209.aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/ms141209.aspx</a>
</div>


Section 2 from  ( What permissions do I need to run the wizard? )

https://msdn.microsoft.com/en-us/library/ms141209.aspx [https://msdn.microsoft.com/en-us/library/ms141209.aspx]

<div>
<div class="content wysiwyg-content">
What is the absolute minimum access would I need to a SQL Server database in order to import a non-system table from that database?<br />
<br />
and<br />
<br />
What is the absolute minimum access would I need to a SQL Server database in order to import a system table from that database?<br />
<br />
<br />
If you have to be an admin or something, is there a way to still restrict the account's access to Read or something very limited?<br />
<br />
<br />
Thanks!
</div>
</div>


What is the absolute minimum access would I need to a SQL Server database in order to import a non-system table from that database?

and

What is the absolute minimum access would I need to a SQL Server database in order to import a system table from that database?


If you have to be an admin or something, is there a way to still restrict the account's access to Read or something very limited?


Thanks!

Access Required to Import SQL Server Table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.