• When You impersonate that user and tun SELECT USER_NAME(), what do you get?

    Next: what does sys.fn_mypermissions return?

    Andreas

    ---------------------------------------------------
    MVP SQL Server
    Microsoft Certified Master SQL Server 2008
    Microsoft Certified Solutions Master Data Platform, SQL Server 2012
    www.insidesql.org/blogs/andreaswolter
    www.andreas-wolter.com