SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Permission issue for excute export /import


Permission issue for excute export /import

Author
Message
solomon.jernas
solomon.jernas
Old Hand
Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)

Group: General Forum Members
Points: 300 Visits: 979
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
durai nagarajan
durai nagarajan
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1609 Visits: 2775
http://msdn.microsoft.com/en-us/library/ms140052(v=sql.90).aspx

hope this helps

Regards
Durai Nagarajan
solomon.jernas
solomon.jernas
Old Hand
Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)

Group: General Forum Members
Points: 300 Visits: 979
Please can you give proper inputs for that/
Lowell
Lowell
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28185 Visits: 39951
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search