EXECUTE permission was denied on the object

exec sp_grantdbaccess N'www1-w(username)', 'DBNAME'

GRANT EXECUTE ON objectname  TO public

SELECT * FROM master.sys.database_permissions AS dp

    JOIN sys.system_objects AS so

    ON dp.major_id = so.object_id

    WHERE dp.class = 1 AND so.parent_object_id = 0 ;