Home -> Usenet -> comp.databases.oracle -> HELP: Viewing GRANTEEs of roles that I have granted

HELP: Viewing GRANTEEs of roles that I have granted

From: Ned Hamilton <esh6n_at_brain.neuro.virginia.edu>
Date: Sat, 18 Feb 1995 20:54:29 GMT
Message-ID: <D47rEt.K7A_at_murdoch.acc.Virginia.EDU> 






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




=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=

Received on Sat Feb 18 1995 - 21:54:29 CET












Original text of this message