Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Permission issue for excute export /import Expand / Collapse
Author
Message
Posted Wednesday, October 24, 2012 7:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 9:58 AM
Points: 151, Visits: 810
In my environment , application owner asking sysadmin rights for excute import /export wizard, but in dba side wont provide the sysadmin rights.. Could you tell me which permission need to give for excute import /export data?



Thanks
Jerry



Post #1376482
Posted Wednesday, October 24, 2012 8:51 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
http://msdn.microsoft.com/en-us/library/ms140052(v=sql.90).aspx

hope this helps



Regards
Durai Nagarajan
Post #1376527
Posted Wednesday, October 24, 2012 12:03 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 9:58 AM
Points: 151, Visits: 810
Please can you give proper inputs for that/
Post #1376613
Posted Wednesday, October 24, 2012 1:54 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:02 PM
Points: 12,890, Visits: 31,853
solomon.jernas (10/24/2012)
Please can you give proper inputs for that/


the import/export wizard is just an application. once you have a user name/password so you can loginto SQL server, you can use ANYTHING to connect with those credentials, SSMS, a custom application, LinqPad,Word,Excel, you name it.

if you can click SSMS, then you inherit the ability to run the import export wizard. Now wether you can read anything on the SQL server beyond that....

From there, if you want to do something you need base permissions on the objects...SELECt to export from a table or view, INSERT/UPDATE permissions in import.

the link provided has specifics:

To complete the SQL Server Import and Export Wizard successfully, you must have at least the following permissions:
Permissions to connect to the source and destination databases or file shares. In Integration Services, this requires server and database login rights.

Permission to read data from the source database or file. In SQL Server 2005, this requires SELECT permissions on the source tables and views.

Permissions to write data to the destination database or file. In SQL Server 2005, this requires INSERT permissions on the destination tables.

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.



Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1376650
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse