Guys I need help setting up permissions for our cubes that are running on SQL 2008. I have creating two roles for each cube one role for full access and the other role for read definition. Now with that said I also gave the read access on the database that the cube is pulling from. My problem is the users that have read definition role can't refresh the cube but if I put them in the admin role everything works fine so guys can you please tell me what I'm doing wrong.