Grants via a role are not applicable inside a proc - the grant will have to be made to the user directly.