Grant Permissions for Viewing Object Definitions

Here's a way to grant permissions to view object definitions.  Very handy when you don't want someone to have full sysadmin permissions.

--------------------------------------------------

-- View Definition Permissions

-- Group in domain is called Admin_ViewDefinition

--          or, specify a user individually

--------------------------------------------------

Use Admin

Exec sp_addrole 'db_ViewDefinition'

Exec sp_addrolemember @rolename = 'db_ViewDefinition',@membername = 'MyDomainName\Admin_ViewDefinition'

GRANT VIEW Definition TO db_ViewDefinition