It's not working with Resource - View rights. Also, we can't provide that right in our company.
Rather found a good and easiest way.
UPDATE cmn_sec_users
SET use_proxy = 1,
start_date = '2018-10-10 00:00:00.0', (sample)
end_date = '2018-10-17 23:59:00.0', (sample)
proxy_user_id = 'internal id of Proxy user',
WHERE id = 'user_internal_id'