| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Regarding privillage,Urgent
Hi Saroj
You must revoke the privilege
delete any table and insert any table from User U.
If you grant the User U connect role he will be able to connect as the user
U but not
delete/insert any data from other users.
Granting delete/insert any table is a very dangerous permission.
HTH
Suhen
-----Original Message-----
From: Dash, Saroj (CAP,CEF) [mailto:Saroj.Dash_at_gecapital.com]
Sent: Thursday, 16 November 2000 15:46
To: Multiple recipients of list ORACLE-L
Subject: Regarding privillage,Urgent
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.
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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dash, Saroj (CAP,CEF)
INET: Saroj.Dash_at_gecapital.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 15 2000 - 23:53:26 CST
 |
 |