In stored procedures, roles are disabled. Hence any privilege granted by a role (DBA), will not be in
effect. The privilege needed must be explicitly granted to the user

Thats all I can think for the errors you are getting...