| 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
you might not be able to revoke them privs, but they can be stopped via
schema triggers in 8i. if anyone would like to see an example, let me =
know.
Joe
-----Original Message-----
From: djordjej [mailto:djordjej_at_home.com]
Sent: Thursday, November 16, 2000 7:35 AM
To: Multiple recipients of list ORACLE-L
Subject: 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=B3'=CCf=81fbfZ=81[fW-----
=8D=B7=8Fo=90l: Suhen Pather [mailto:Suhen.Pather_at_strandbags.com.au]
'-=90M"=FAZz: Thursday, November 16, 2000 PM 02:55
^=B6=90=E6: Multiple recipients of list ORACLE-L
OE=8F-=BC: 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 =
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.
--
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 also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: djordjej
INET: djordjej_at_home.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 Received on Thu Nov 16 2000 - 08:20:24 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |