RE: Table access

Hi!

The data dictionary contains information about all objects created in
the database... And the all_tab_privs contains information about grants
on objects for which the user is the grantor, grantee, owner, or an
enabled role or PUBLIC is the grantee. So you just have to query
something like this...

SELECT * FROM all_tab_privs WHERE table_schema = 'ADB'

Note that you will see only the objects accessible by the user that you
are connected with.
Hope this helps! Have a good day!!!


pep0. <-- www.pep0.demon.co.uk --> ... Do you have a developer vacancy
in London? contact me! ...


> -----Mensaje original-----
> De: Bandiatmakur, Ravi [mailto:[email protected]] 
> Enviado el: jueves, 13 de marzo de 2003 7:13
> Para: Oracle
> Asunto: [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].