RE: Table Insert Lock!!

Hi subra( my ex-pm name),

Hope that ur not pricise in ur ?.

If suppose to keep at maxinum of 1 record at time( like dual), you can restrict this, by
table level trigger of INSERTING.

Sorry if i was u/s wrongly.

Nirmal.

> -----Original Message-----
> From: ayyappan.subramaniyan_at_ssiworldwide.com
> [SMTP:ayyappan.subramaniyan_at_ssiworldwide.com]
> Sent: 15 محرم, 1423 03:43 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Table Insert Lock!!
>
> 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: Nirmal Kumar  Muthu Kumaran
  INET: NIRMALK_at_qtel.com.qa

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