Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    26

    Unanswered: Need to know SQL User Permission

    Hi ,

    One on my SQL users wants to execute few sql system stored procedure and wanna execute Bulk insert on the database server .. SO what permission should be assigned to the users to that he can do his desigred above task.


    Thanks

    Rubal

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: Need to know SQL User Permission

    BOL:
    Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.

    About select and insert permissions - it is question for you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •