Wednesday, November 13, 2013

script to find what are the objects accessed by user?

SET LINESIZE 255
 SET VERIFY OFF
 COLUMN object FORMAT A30
SELECT a.object, a.type, a.sid, b.username, b.osuser, b.program FROM v$access a, v$session b WHERE a.sid = b.sid AND a.owner = UPPER('&1') ORDER BY a.object;

No comments:

Post a Comment