Post reply

Insert Permission denied

  • May 28, 2013 at 10:52 am

    #278244

    I am working on getting permissions setup for an intern to be able to create/alter SP's as well as read/write permissions within a couple of databases. I had tried making them public and then mapping to the appropriate databases with db_reader and db_writer, then on the database gave them the permissions to create procedure, as well as alter and execute. This allowed them to do what they needed with the SP's, but now are not able to run an insert against any table on this database. They can do inserts into other databases on the instance. I have tried giving the account db_owner permissions on the database and still didn't work. The only way that I can get it to work is by giving the account SA permissions on the server, which you can see the issue there. I even created a new account for my personal login with the exact same permissions and it works just fine. I am not seeing any DB permission that would be denying it.

    The only difference that I can see between my account and the one for the intern is the naming convention. Mine is jdavis, as to where the interns is Jason.Davis. Is there any issue within SQL where there is naming convention like this with a period on the name?

    Thanks in advance for the help!

  • May 28, 2013 at 11:01 am

    #1619060

    Have you tried [Jason.Davis]?

  • May 28, 2013 at 3:03 pm

    #1619123

    The account format is actually Domain\jdavis for me (First Initial Last Name), but for the intern it is Domain\Jason.Davis (FirstName.LastName).

    I have even tried deleting the login from the server completely and re-creating but that still does not work. Even when the account is deleted I still get results from this query, which I would think that there would not be any results, or at least get an error on the execute as statement.

    EXECUTE AS USER = 'Domain\User.Name';

    SELECT * FROM fn_my_permissions ('TableName', 'Object')

    I have went through and made sure the login does not exist in any of the databases or under server security. It does not show up in sys.server_principals, or sys.database_principals.

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

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