Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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
1  
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

 
discard

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.