audit table with permissions

[chris <chrisk@xxxxxxxxxxxxxxx>]

I created functions and a trigger to audit tables on my database but I 
have a problem with permissions on the functions and function schema I 
created. I can grant permissions to the current user of the original 
table being audited but I need a way to automate grants and revokes made 
to the original table so that any time those change in the future I 
don't have to worry about updating permissions or leaving a hole in 
security by granting all users full permissions to the functions and 
function schema.

From my understanding event triggers can't be set the grant/revoke only 
create, alter or drop.

Any input would really help me, I'm very fresh to writing functions and 
triggers.

Thanks,

Chris