Re: User rights

From: Peter Alteheld <palteheld_at_yahoo.de>
Date: Fri, 29 Apr 2005 14:07:48 +0200 (CEST)
Message-ID: <20050429120748.8848.qmail@web26505.mail.ukl.yahoo.com>

Hi Michael,  

Did you try SELECT_CATALOG_ROLE?
HTH, Peter

Michael.Fleck_at_lvr.de wrote:
Hi list members,

we have some people in our departments, which do some user administration. The employees of this department work with oracle applications. Ths support people in the department want to know, which access a user has to what tables, indexes etc. Which role or system-rights do I have to grant to the support people in the department. With DBA rights they get the right information. I tried the roles SELECT_ANY_CATALOG and EXECUTE_ANY_CATALOG and the SELECT_ANY_DICTIONARY right, but none of them worked.

Any ideas, which right I have to grant?

Best regards,
Michael Fleck=20

Landschaftsverband Rheinland
LVR InfoKom
Leiter Produktion
Tel: 0221/809/2826
email: michael.fleck_at_lvr.de=20
--

http://www.freelists.org/webpage/oracle-l                 

---

Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 29 2005 - 08:12:08 CDT