Post reply

You do not have permission to use the bulk load statement

  • June 21, 2012 at 7:53 am

    #258351

    Hi,

    I've got 2 users, an administrator and Bob.

    Both are SysAdmin

    When I'm logged in as administrator I can execute

    SELECT CAST(x AS XML)

    FROM OPENROWSET(

    BULK 'c:\Data\FileName.csv',

    SINGLE_BLOB) AS T(x)

    I can then run SETUSER Bob and run it again and it's OK.

    However if I log in as Bob it returns the error

    "You do not have permission to use the bulk load statement"

    Bob is a local admin and the C:\Data\ folder is shared to everyone with full permissions.

    Bob also has the BulkAdmin role.

    Strange sympton is when I'm logged in as Administrator I can see Bob and his Server Roles, but when Bob logs in he can't even see his Login.

    So to me I looks like Bob is lacking a permission but I can see he has SysAdmin.

    Any clues would be appreciated.

    Thanks.

    Giles

  • June 21, 2012 at 1:39 pm

    #1504201

    A sysadmin can't be denied anything in SQL Server, so something else is going on here.

    Is this a SQL login or a Windows login?

    If W, is it a group or user login?

    When you say you can "see that Bob is a sysadmin", what specifically are you looking at?

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • June 21, 2012 at 1:50 pm

    #1504208

    If bob is given access via the administrators group and is running the app locally on Win7 then he needs to right click on it and select run as administrator. Otherwise Windows won't resolve the fact that he is a local admin.

  • June 28, 2012 at 6:57 am

    #1506579

    Plese Help! I am new here and going out of my mind.

    I am using an Application Role for the first time. When my user is running the BULK UPLOAD I get "You do not have permission to use the bulk load statement."

    Now, I have placed that user as a BULKADMIN and then subsequently as SYSADMIN and he still cannoy use it after he has activated the application role.

    Is there anything else I need to do? I am desperate and tired and about to give up application roles, even though they are fab for managing permissions.

    Frank

  • June 28, 2012 at 7:04 am

    #1506588

    Take a look at the last two posts. Can you answer those questions? And what I said applies to Server 2008 too, not just Win7.

  • June 28, 2012 at 7:08 am

    #1506591

    Hello Sir, I have indded read the last two posts.

    If I run this outside the Application Role, it runs just fine. If I run the procecess after activating an application role, I get Permissions Error.

    I have added to the SPROC "With EXECUTE AS Proxy" but it still will not run. The Application role does not have access to the BULK ADMIN account.

    How do I set up application roles to run with BULK INTO?

    I am running SQL 2005.

  • June 28, 2012 at 7:20 am

    #1506599

    I haven't used application roles before. Hopefully someone that has will take a look and help out.

Viewing 7 posts - 1 through 6 (of 6 total)

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