• Check the permissions on the objects with DENY

    select p.name, p.type_desc,OBJECT_NAME(dp.major_id),OBJECT_SCHEMA_NAME(dp.major_id), dp.permission_name, dp.state_desc

    from sys.database_permissions dp

    inner join sys.database_principals p on dp.grantee_principal_id = p.principal_id

    where dp.state <> 'G'

    Edit, actually it'll be the DENY at the database level for principal_id = 54

    So check who that is - if it's S\I then fix the permissions by using a REVOKE

    select p.name, p.type_desc

    from sys.database_principals p

    where p.principal_id = 54