grants for procedures do not work through a role, u have to grant individually on each objects.