How to compile all procedures in a database. what are the priviledges do we need for that.
thanks