Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to track, who are using the particular table in oracle using sql or pl/

orabitsJun 2 2009 — edited Jul 1 2009
we have database DB1 and it contains schema s1 and the schema s1 contains all the user defined objects including tables and others and it contains one of the table name called t1. we have users u1, u1, u2...uN.

Now, I want to track who are all using that particular table t1 under schema s1 (track user, time).

How to do this from sql OR pl/sql
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2009
Added on Jun 2 2009
9 comments
1,142 views