• Hello again,

    A couple of other thoughts:-

    1) Although you have granted permissions to the Object XYZ to the Login, is there any possibility that they are in a Group that explicitly has these permissions denied?

    2) Is Object XYZ a View? If so, do all the underlying Objects belong to the same Owner?

    (Just in case these suggestion help).

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group