AW: User rights

From: <Michael.Fleck_at_lvr.de>
Date: Fri, 29 Apr 2005 15:51:40 +0200
Message-ID: <4C8A1155526567458C3328A3B56EC00B01F149C4@msx-zv02.lvrintern.lvr.de>

Thanks a lot.

Our problem is, that we use a GUI-based third party tool for these guys = in our department. I don't know which queries lie behind the button for = the user rights. I gave the users Select on DBA_TAB_PRIVS and = DBA_ROLE_PRIVS, so they can query the user rights from SQL-Plus, but = with the tool this doesn't work. I think, I will contact the support = people of the tool.

Best regards,
Michael Fleck=20

-----Urspr=FCngliche Nachricht-----
Von: Vitalis Jerome [mailto:vitalisman_at_gmail.com]=20 Gesendet: Freitag, 29. April 2005 14:59
An: Fleck, Michael
Cc: oracle-l_at_freelists.org
Betreff: Re: User rights

On 4/29/05, Michael.Fleck_at_lvr.de <Michael.Fleck_at_lvr.de> wrote:
> Hi list members,

>=20

> we have some people in our departments, which do some user=20
> administration. The employees of this department work with oracle=20
> applications. Ths support people in the department want to know, which =

> access a user has to what tables, indexes etc. Which role or=20
> system-rights do I have to grant to the support people in the=20
> department. With DBA rights they get the right information. I tried=20
> the roles SELECT_ANY_CATALOG and EXECUTE_ANY_CATALOG and the=20
> SELECT_ANY_DICTIONARY right, but none of them worked.

>=20

> Any ideas, which right I have to grant?

>=20

> Best regards,
> Michael Fleck=3D20

Hi Michael,

Which queries do the support guys exactly use for this purpose? They = can't only query dba_catalog since this won't tell them which objects a = user can access. They must be using some queries against DBA_TAB_PRIVS = and the like. If you can get their queries, it might be easier to find = the right sufficient role or privileges.

Regards,
Jerome

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

Received on Fri Apr 29 2005 - 09:56:02 CDT