Hi all,

I have 400 users created on my Oracle DB (ver. 8) on Unix. I want to drop 25 Users out of 400, before that i want a list of users who are having Object privileges on these 25 users objects (means objects owned by these 25 users).

Please can any one give me a good query for getting the above result.

Thanks,

UpeshP