AW: User rights
- From: <Michael.Fleck@xxxxxx>
- To: <vitalisman@xxxxxxxxx>
- Date: Fri, 29 Apr 2005 15:51:40 +0200
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@xxxxxxxxx]=20
Gesendet: Freitag, 29. April 2005 14:59
An: Fleck, Michael
Cc: oracle-l@xxxxxxxxxxxxx
Betreff: Re: User rights
On 4/29/05, Michael.Fleck@xxxxxx <Michael.Fleck@xxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
