RE: Table access

Select * from dba_tab_privs
Where owner =3D 'ADB';

-----Original Message-----
From: Bandiatmakur, Ravi [mailto:[email protected]]=20
Sent: Thursday, March 13, 2003 2:13 AM
To: Oracle
Subject: [oracle] Table access

Hi all,

I want to know which user has what kind of access to different tables in
a
schema. I have a schema called
as ADB and i want to know the different access privileges the users have
over the tables in this schema.

Any help will be appreciated.

Thanks,
Ravi.




____________________________________________
Confidential:  This electronic message and all contents contain
information
from Syntel, Inc. which may be privileged, confidential or otherwise
protected from disclosure. The information is intended to be for the
addressee only. If you are not the addressee, any disclosure, copy,
distribution or use of the contents of this message is prohibited.  If
you
have received this electronic message in error, please notify the sender
immediately and destroy the original message and all copies.

---
Change your mail options at http://p2p.wrox.com/manager.asp or=20
to unsubscribe send a blank email to %%email.unsub%%.

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].