no, you cannot access stored procedures via roles