From: mcstockX@Xenquery   
      
   "Denis Martineau"  wrote in message   
   news:27314556.0403041435.ec1f88f@posting.google.com...   
   | Some user accounts have been created some time ago and we have just   
   | found out that they were given privileges they should not have.   
   | However, I have no idea which account was used to create them and when   
   | I use a DBA account to revoke these privileges I get the following   
   | message: "ORA-01927: cannot REVOKE privileges you did not grant"   
   |   
   | Any idea how to revoke these accesses?   
      
      
   only the owner of an object can grant/revoke object privileges (this is why   
   roles are such a good idea)   
      
   connect as the owner of the object and you will have certain success   
      
   (the same is not true for system privileges)   
      
   -{ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)