Re: HELP: Viewing GRANTEEs of roles that I have granted

In article: <D47rEt.K7A_at_murdoch.acc.Virginia.EDU> esh6n_at_brain.neuro.virginia.edu (Ned Hamilton) writes:
>
> How can I see to whom I have granted roles that I CREATEd or that I
> have admin option for?
>
> There doesn't seem to be a view that lets me see this (unless I am
> SYSTEM). I ought to be able to get this info. If I try to
> revoke a role from someone who doesn't have it, I get error message from
> Oracle telling me that the user doesn't have that role.
>
> =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
> Ned Hamilton NTC Department of Neurosurgery
> nedh_at_virginia.edu University of Virginia
> =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
>
>

-- 

	Fundamental concept problem here. Roles are not owned by 
anybody.

	role_tab_privs
	role_sys_prive
	dba_roles

---
	Tim London			phone :	+44 753 662393
	Oracle DBA,Trainer and		mobile:	+44 836 287064
	part time OU tutor		Email : tim_at_artemis.demon.co.uk