Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: PRODUCT_PROFILE restrictions on a particular table

Re: PRODUCT_PROFILE restrictions on a particular table

From: <cjgait_at_earthlink.net>
Date: Thu, 17 Aug 2000 20:48:07 -0400
Message-Id: <10592.114922@fatcity.com>


Joseph's solution sounds like a winner for pre-8.1.5 DBs, but in 8i you can create a function and use fine-grained security to not permit a particular schema to be able to update a table, even it's own. This applies to all schemas except SYS.

Regards,
Chris Gait

On 16 Aug 2000, at 4:10, Joseph S. Testa wrote:

> 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
> --
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.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 Aug 17 2000 - 19:48:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US