Nice. I see myself returning to this page in the future. I also see moderators in the forum linking n00bs to this page. I further see those n00bs complaining that "conn / as sysdba" won't accept my password, or "The DBA won't let me have DBA role ... or CREATE DIRECTORY ... or PUBLIC access to a Directory". I recall you mentioned something about bad practices ... :-)
John, do you have a Dev-friendly version? What is the minimum privs a bog-standard Dev would need to ask their DBA for?