Post reply

Attach/detach permissions

  • January 13, 2009 at 9:43 am

    #92923

    I need to grant a user permissions to detach/attach and export data.

    I also need to grant a user export only permissions.

    Best advice?

  • January 13, 2009 at 10:21 am

    #926060

    hawkeyeboy (1/13/2009)

    I need to grant a user permissions to detach/attach and export data.

    I also need to grant a user export only permissions.

    Best advice?

    Attach = I think as a member of the db_creator role on the server. Not sure on this one.

    Detach = member of the db_owner role within the database

    Extract = SELECT permissions on every table and view within the database. In SQL Server 2000 this is usually accomplished with the db_datareader role in the database.

    K. Brian Kelley
    @kbriankelley

  • January 13, 2009 at 10:44 am

    #926080

    I agree with Brian about permission for sp_attach_db, but SQL 2000 BOL says only members of sysadmin can execute sp_detach_db (I'm assuming the OP is using SQL 2000).

    What method do you want to use for exporting? BCP? Import/Export Wizard? Different permissions are required for each.

    Greg

  • January 13, 2009 at 11:24 am

    #926116

    I'd go with the SQL Server 2000 BOL, then. I'm looking at the 2005 BOL which lists db_owner.

    K. Brian Kelley
    @kbriankelley

  • January 13, 2009 at 2:46 pm

    #926254

    Thanks guys....yes my research showed the same results.

    I believe they will be using the import/export feature.

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

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