• The user still has VIEW DEFINITION in the database, as it was granted VIEW ANY DEFINITION on server level.

    That is, the user can see the definition of all tables, stored procedures etc.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]