Post reply

Import/Export Security

  • December 21, 2004 at 11:04 am

    #87354

    Who has the authority to import or export data from a database? If a login has the ability to import/export data, is there a way to restrict them from being able to do this?

  • December 21, 2004 at 5:05 pm

    #534696

    By default, anyone can run the import/export wizard or create a DTS package, but they have to have permission to insert into the destination tables to make it work import and permission to read the source table to export.  So, the user must have object level insert and read permission, or be a member of the db_datawriter and db_datareader database roles, or the user's related login must be a member of the sysadmin server role.

    So, if you want to restrict someone from importing or exporting, don't give them the above permissions or role memberships.

    Greg

     

     

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

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