Re: Objects and synonym

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 22 Mar 1999 16:35:16 +0800
Message-ID: <36F600C4.195D@bhp.com.au>

tyann_at_aol.com wrote:
>
> Anyone know how to list the names of all the users whose objects one has
> access to in a database?
>
> How do you show the synonym and who ones the synonym for a certain
> table. Egs (Customer)

Start with DBA_TAB_PRIVS and DBA_ROLE_PRIVS and see if that is what you are after...

Similarly for synonyms, DBA_SYNONYMS
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Mon Mar 22 1999 - 02:35:16 CST