Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Regarding privillage,Urgent
A role is a pack of system and/or object privileges, introduced for easier
maintenance. For example CONNECT role has the following sys privileges:
alter session, and create table/synonym/cluster/sequence/database
link/sysnonym/view. These creates mean that user can create its own tables.
Every user by default can drop and alter his/her own tables - there is no
privilege that you grant and/or revoke for those.
Djordje
By the way the user U can not create table ,for that what is the permissiom i will give.
What do u mean by role CONNECT. what it does.
-----OE'ffbfZ[fW-----
ol: Suhen Pather [mailto:Suhen.Pather_at_strandbags.com.au]
'-M"Zz: Thursday, November 16, 2000 PM 02:55
^: Multiple recipients of list ORACLE-L
OE-: 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-----
Sent: Thursday, 16 November 2000 15:46
To: Multiple recipients of list ORACLE-L
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 tableto 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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Received on Thu Nov 16 2000 - 06:33:46 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |