Just thought I'd post this link:
http://www.petefinnigan.com/tools.htm
The find_all_privs.sql script is different to any others I've seen. It is able to cope with system and object privileges assigned via nested roles .:cool: Thought someone might find it useful