OK thanks, good to know. I'll see if I can get access to that login here, and if that does work maybe I can figure out which security policy I need.

11g (11.1.9.0 methinks). The mismatch doc is from MOS - 1955595.1, might be relevant, might not be, but it's what I would check next. Good question about the Admin Roles, I guess I'll have to dig further. But in general - deleting and creating aggregates should be possible via Admin > Issue SQL, right?

Hi, thanks for the reply. I'm logged in as my own account but I have both "BI Administrator Role" and "BIAdministrators" (with an 's'). Should be good enough, right?