?: Regarding privillage,Urgent

From: Dash, Saroj (CAP,CEF) <Saroj.Dash_at_gecapital.com>
Date: Thu, 16 Nov 2000 15:12:08 +0900
Message-Id: <10681.122222@fatcity.com>

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=20
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,
=20
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.=20

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.=20

But i have given the permission GRANT DELETE any table,insert any = table
to U.=20
Question: so the problem if he login to U and he alos delete the = the X
user's table.=20

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.

--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20

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).
--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20

Author: Suhen Pather
INET: Suhen.Pather_at_strandbags.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------