Regarding privillage,Urgent

From: Dash, Saroj (CAP,CEF) <Saroj.Dash_at_gecapital.com>
Date: Thu, 16 Nov 2000 13:41:37 +0900
Message-Id: <10681.122217@fatcity.com>

Hi,  

 I have create a user X whose has admin permission. other than system and sys. I have given the permission to X is like this.

                     grant delete any table,insert any table to X. 

    Now i created another user 'U' for the user can login to this U only.
     HE can delete,select,insert,update only those tables which he owned. 
     But i have given the permission GRANT DELETE any table,insert any table

to U.
  Question: so the problem if he login to U and he alos delete the the X user's table.

   Please tell me how cam i give the grant permission so that U user can not delete the X user's tables.

   he(U user) can do select,update,delete of his owned tables. Received on Wed Nov 15 2000 - 22:41:37 CST