Jaremy, the owner of the procedure needs to have an alter user privilege the grantee does not this is what definer rights are about On Mon, Jan 12, 2009 at 4:33 PM, SHEEHAN, JEREMY <JEREMY.SHEEHAN@xxxxxxx> wrote: > Is there anyway around allowing users to unlock accounts and change password > without granting 'ALTER USER'? -- Alex Fatkulin, http://afatkulin.blogspot.com http://www.linkedin.com/in/alexfatkulin -- //www.freelists.org/webpage/oracle-l