Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm working in a environment where there are a large variety of legacy client programs. I'm trying to get an idea of which programs use what stored procedures. Is there a way to audit access to a stored procedure without having to modify said procedure? I could figure what each procedure accesses and add audit triggers for the underlying objects, but there are a lot of procedures to examine. Identification of DB user and ideally hostname would be sufficient. I took a peek at the FGA package, but couldn't see how to apply it to procedures.

Disclaimer: I'm not a DBA, so my terminology may be imprecise. Apologies in advance.

share|improve this question
up vote 2 down vote accepted

Have you looked at the AUDIT command? There is a provision in the command to audit stored procedures:

AUDIT ALL ON schema.procedure;

You will, of course, need to enable auditing on your database.

share|improve this answer
Thanks. I did see AUDIT, but I didn't fully get the meaning of ON schema_object_clause – David J. Liszewski Oct 29 '09 at 1:44

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.