Home » SQL & PL/SQL » SQL & PL/SQL » Table/User Information
Table/User Information [message #442074] Thu, 04 February 2010 11:03 Go to next message
decci_7
Messages: 68
Registered: March 2006
Member
Is there a way to identfy who is accessing a given table?

for example i have an employee table in my database, i need to find who are the users that access this table, what are the applications that access this table...are there any dblinks to access data in and out of this table...

How do i do it?
Thanks!
Re: Table/User Information [message #442087 is a reply to message #442074] Thu, 04 February 2010 11:34 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
AUDIT the table

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4007.htm#i2059073
Re: Table/User Information [message #442096 is a reply to message #442074] Thu, 04 February 2010 11:51 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
...are there any dblinks to access data in and out of this table

This is meaningless a db link does not access a table.

As BlackSwan said, AUDIT is made for this.

Regards
Michel
Re: Table/User Information [message #442098 is a reply to message #442074] Thu, 04 February 2010 12:09 Go to previous message
decci_7
Messages: 68
Registered: March 2006
Member
Thanks!!
Yep .. agreed .. DBLink is smething I shouldnt have mentioned here.
Previous Topic: Oracle + 2 select querys + minus + order by + decode help...
Next Topic: Pls Help!
Goto Forum:
  


Current Time: Thu Sep 29 10:50:03 CDT 2016

Total time taken to generate the page: 0.15055 seconds