Re: User rights
- From: Peter Alteheld <palteheld@xxxxxxxx>
- To: Michael.Fleck@xxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 29 Apr 2005 14:07:48 +0200 (CEST)
Hi Michael,
Did you try SELECT_CATALOG_ROLE?
HTH, Peter
Michael.Fleck@xxxxxx 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@xxxxxx=20
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher
--
//www.freelists.org/webpage/oracle-l
Other related posts:
