Insufficient SQL database permissions for user on SQL Server instance, the EXECUTE permission was denied on the object proc_GetProductVersions

I was getting ‘Insufficient SQL database permission’ issue in event viewer and 14 hive log file if I create any sub-site into 2010 environment. from user interface I didn’t see any errors.

Here is alternative option for this issue by granting permission into SQL server database.

Resolution links:

http://sharepointsoldiers.wordpress.com/2011/10/09/insufficient-database-permissions-proc_getproductversions-eventid-5214/

http://sajiviswam.wordpress.com/2011/05/24/the-execute-permission-was-denied-on-the-object-proc_getproductversions-insufficient-sql-database-permissions-for-user/