Re: PRODUCT_PROFILE restrictions on aparticular table

Not sure why you would want the schema owner to not be able to update their own table, but here goes:

create a trigger on that table that does a before update and raises an exception, it will need to be owned by someone other than the schema owner and that person will need create any trigger.

unless i'm missing something here(is the question as easy as revoke update priv on the table from everyone and i've read too much into it?)

joe

ALEMU Abiy wrote:
>
> Hi friends,
>
> I know how to disable a given command of SQL*Plus to a user but what I would
> like to know is if it's possible to disable a given command on a given
> table. For example, if I want to disbale the UPDATE command to SCOTT on the
> EMP table, is there a way to do it ?
>
> Please help !!!!
>
> ----------------------------------------------------------------------------
> --------
> @biy @lemu
> abiy.alemu_at_criltelecom.com <mailto:abiy.alemu_at_criltelecom.com>
> Cril Telecom Software
> France
>
> --
> Author: ALEMU Abiy
> INET: abiy.alemu_at_criltechnology.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).

-- 
Joe Testa  http://www.oracle-dba.com
Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs