Revoke Delete

2001-11-27 Thread Aldi Barco
Hi Listers, How can we revoke 'delete privilege' from the schema owner of the table and also from DBA ? If it is not possible, can we set through trigger ? Thanks. Aldi _ Get your FREE download of MSN Explorer at http

Re: Revoke Delete

2001-11-27 Thread Paul Baumgartel
[EMAIL PROTECTED] wrote: Hi Listers, How can we revoke 'delete privilege' from the schema owner of the table and also from DBA ? If it is not possible, can we set through trigger ? Thanks. Aldi _ Get your FREE download

RE: Revoke Delete

2001-11-27 Thread Mohan, Ross
revoke 'delete privilege' from the schema owner of the table and also from DBA ? If it is not possible, can we set through trigger ? Thanks. Aldi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services

RE: Revoke Delete

2001-11-27 Thread Ron Thomas
: RE: Revoke Delete com

RE: Revoke Delete

2001-11-27 Thread Jack C. Applewhite
from the schema owner, but that doesn't solve the problem of DBA-privileged accounts being able to delete. I'm guessing that this is a perfect opportunity to use an INSTEAD OF trigger. --- Aldi Barco [EMAIL PROTECTED] wrote: Hi Listers, How can we revoke 'delete privilege' from the schema owner

RE: Revoke Delete

2001-11-27 Thread Deepak Thapliyal
] Sent by: cc: root@fatcity.Subject: RE: Revoke Delete com

RE: Revoke Delete

2001-11-27 Thread Mohan, Ross
[EMAIL PROTECTED] MohanR@STARS- SMI.com To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: Revoke Delete com 11/27/01

RE: Revoke Delete

2001-11-27 Thread Mohan, Ross
to use an INSTEAD OF trigger. --- Aldi Barco [EMAIL PROTECTED] wrote: Hi Listers, How can we revoke 'delete privilege' from the schema owner of the table and also from DBA ? If it is not possible, can we set through trigger ? Thanks. Aldi