Re: query for roles granted to users

From: Arnold Schommer <aschommer_at_fs-edv.de>
Date: Mon, 10 Aug 1998 14:07:25 +0200
Message-ID: <35CEE27D.8ADA8352@fs-edv.de>

NDF wrote:
>
> Hello all,
>
> Does anyone know of a query that I could use to see what roles I as a
> user have granted to other users?
>
> What I'm looking for is a data dictionary view that is similar to the
> USER_TAB_PRIVS_MADE except for roles rather than privileges.
>
> Thanks for any pointers!
>
> - NDF.
all_role_privs shows _all_ roles granted; user_role_privs shows all roles granted _to_ you, not _by_ you.

Hope it helps Received on Mon Aug 10 1998 - 07:07:25 CDT