Post reply

Permission issue for excute export /import

  • October 24, 2012 at 7:44 am

    #393450

    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

  • October 24, 2012 at 8:51 am

    #1552308

    http://msdn.microsoft.com/en-us/library/ms140052(v=sql.90).aspx

    hope this helps

    Regards
    Durai Nagarajan

  • October 24, 2012 at 12:03 pm

    #1552378

    Please can you give proper inputs for that/

  • October 24, 2012 at 1:54 pm

    #1552409

    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!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply