Who has created the procedure? [message #19859] |
Sun, 14 April 2002 04:30 |
petra
Messages: 5 Registered: April 2002
|
Junior Member |
|
|
hallo,
I need information about the person who has created a specific procedure, e.g the name of the OS-User
Where can I find this information?
Thanks in advance
Pit
|
|
|
Re: Who has created the procedure? [message #19860 is a reply to message #19859] |
Sun, 14 April 2002 22:45 |
Satish Shrikhande
Messages: 167 Registered: October 2001
|
Senior Member |
|
|
Create a Table USERAudit ,Write a SCHEMA or DATABASE level Triiger , Trap the ora_sysevent,ora_login_user and ora_dict_object and do the auditing . Get the information when and which user has created the DB object .
For further information look for system level triggers and find ON SCHEMA trigger .
Satish Shrikhande
|
|
|