Re: Table access

Query DBA_TAB_PRIVS / ALL_TAB_PRIVS to query privileges over the tables
falling in ADB schema.

Hope this helps.

Rgds,

Rakesh.
----- Original Message -----
From: "Bandiatmakur, Ravi" <[email protected]>
To: "Oracle" <[email protected]>
Sent: Thursday, March 13, 2003 12:43 PM
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
> 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].