• Add the user to db_datareader, and grant the user VIEW DEFINITION on database level:

    GRANT VIEW DEFINITION TO nisse

    Note that this gives the user right to see any definition in the database, that is stored procedures, tables, certificates etc. And users.

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