View Stored Procedure Permission
If we want to provide view object definition rights to a specific user with the public role on all databases, execute the following query If we want to provide view object definition rights to a specific user with a public role on a specific database, execute the following query To grant View Definition rights to... » read more