Re: Table Insert Lock!!

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 28 Mar 2002 05:08:22 -0800
Message-ID: <F001.00435D35.20020328050822@fatcity.com>

Create your record, then change the tablespace to be read-only.

OR

Don't grant permissions to insert/update/delete the table to anyone.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, March 28, 2002 7:43 AM

> Hi
>
> I have to revoke insert from a table where I am the owner of the Schema.
is
> it possible. if so? how?.
>
>
> E.g.
> Owner a have a table t1
>
> after inserting 1 row
>
> owner wish to revoke insert for the table t1. because t1 should not have
> more than one row.
> How to incorporate this. it is 8.1.7 on sun Solaris 5.7
>
>
> Regards
>
> Ayyappan.S
>
>
>

---

> This communication contains information, which is confidential and may
also
> be privileged. It is for the exclusive use of the intended recipient(s).
If
> you are not the intended recipient(s), please note that any distribution,
> printing, copying or use of this communication or the information in it is
> strictly prohibited. If you have received this communication in error,
> please notify the sender immediately and then destroy any copies of it.
> Visit us @
>

www.ssiworldwide.com********************************************************


> ********************

> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: ayyappan.subramaniyan_at_ssiworldwide.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.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 Thu Mar 28 2002 - 07:08:22 CST