Post reply

minimum appropriate permissions for a user who would complete imports and exports

  • April 9, 2004 at 3:14 pm

    #110837

    What minimum appropriate permissions would a user have who would complete imports and exports. Should the user have System Administrator role or Bulk Insert Administrator or something else?

  • April 9, 2004 at 3:51 pm

    #502351

    depends on how they do it. Could get by with insert and select (maybe update). Sys admin isn't something I'd give out.

  • April 9, 2004 at 4:00 pm

    #502353

    So when you create a user and you want him to have minimum permission to do imports and exports. Is bulk insert aministrator, database creators, disk administrator, process administrator or is there something else that is appropriate? I'm a little confussed.

  • April 9, 2004 at 4:45 pm

    #502355

    Like I said, it depends. They don't need any of those roles necessarily. If I want someone to run imports via DTS from Excel, I can add him as a user, give him insert rights into the table(s) he will be inserting into, give him rights into msdb (run store/edit/run the package), then he's ok. He doesn't need any roles to do these things. It's just a regular user.

    Those roles are for special things. If you do plan on bulk inserts, any you may need to for some reason, then the person does have to be a bulk administrator to run this command. But not for bcp. They just need a regular login (no roles) and rights to insert or select from some table.

    So how do you plan on importing and exporting? Do you have some flexibility? What is the scope of this project?

  • April 9, 2004 at 5:10 pm

    #502356

    Thanks Steve for your insight. I have a team project for a class assignment and my responsibility is to create a user with minimum appropriate permissions who would complete imports and exports. I see now that I can create this user without any security access roles at this time. And just make him a regular user. For specific functions I could add these special roles but it doesn’t seem necessary at this time.

    My team and I thank you. If you think anything else is necessary to point don’t hesitate to post it.

    Again, many thanks.  

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

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