Post reply

Users with DBO schema denied permissions on table objects after migration to SQL Server 2005

  • January 25, 2008 at 9:23 am

    #183399

    After the migration of a database from SQL Server 2000, users that have been defined prior to and after as DBOs on the database are denied permissions for everything except SELECT actions on the database. A typical message occurs as follows:

    Msg 229, Level 14, State 5, Line 1

    The DELETE permission was denied on the object 'location', database 'Tracks', schema 'dbo'.

    It acts like it is in read-only mode but that value has been reset to no effect. Is this an ownership chain issue? Any thoughts would be appreciated. Thanks.

  • January 25, 2008 at 12:42 pm

    #771978

    Go into the DB\security\schema and give them rights specifically in that schema. So you'll right-click on the dbo schema and go to properties... then give them whatever rights you want them to have.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • March 12, 2008 at 8:50 am

    #788610

    No effect WHATSOEVER. I've added EVERY access right available and it STILL comes up with 'The Delete Permission is Denied' - I'm teariing my hair out - just why does this have to be SOOOH difficult - come back MySql all is forgiven!


    Diane Connors

  • March 13, 2008 at 8:31 am

    #789094

    A DENY permission on an object outranks every other permission they may have been granted else where. Look in all the roles\groups these people are in and see if permissions have been denied anywhere.

    ---------------------------------------------------------------------

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

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