Some updated links on my Oracle security papers page
Fine Grained Access Control
Autonomous Transactions
How to become another user in SQL*Plus
How to generate random numbers in PL/SQL
How to store a password
These are all quite interesting papers and well worth a second visit even if you have previously read them.