Re: Limited update ability?

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Wed, 18 Apr 2012 17:18:06 +0300
Message-ID: <CAN2wOq2o2pC-rJ5d=8iFEg4KSoDXSoy2YoQ=f2JLvLWy-BQeag_at_mail.gmail.com>

It is closer to interface behaviour than Oracles'. For example tool PL/SQL Developer asks me "Are you sure you want to delete all records?" for statement "delete bla", most probable it is configurable, but actually I don't care :)
Also there is one big difference for Oracle and MySQL (at least MyISAM tables) - for Oracle (normally, without some kind of autocommit) one has to issue commit, for MySQL not, so transactions actually are some kind of verification.

Gints

2012/4/18 <Joel.Patterson_at_crowley.com>

> That's what I figured.
> FGA wouldn't prevent accidents, and I don't believe you could prevent the
> accidents with resource manager either.
>
> Anyway, it doesn't hurt to ask 'cause one might presume erroneously.
>
> Thx,
>
> Joel Patterson
> Database Administrator
> 904 727-2546
> From: Igor Neyman [mailto:igor.neyman_at_gmail.com]
> Sent: Wednesday, April 18, 2012 9:26 AM
> To: Patterson, Joel
> Cc: oracle-l_at_freelists.org
> Subject: Re: Limited update ability?
>
> Don't think that Oracle has implementation similar to this.
> The alternatives are:
> - fine-grain access
> - resource manager
>
> Regards,
> Igor Neyman
> On Wed, Apr 18, 2012 at 7:42 AM, <Joel.Patterson_at_crowley.com<mailto:
> Joel.Patterson_at_crowley.com>> wrote:
>
> Somebody, (a manager), asked me if oracle had a limited, (safe), update
> 'option' like MySQL -- as described in this link:
>
> http://dev.mysql.com/doc/refman/5.1/en/mysql-tips.html#safe-updates
>
> has anyone heard of anything similar, or know of anything similar with
> oracle?
>
> Joel Patterson
> Database Administrator
> 904 727-2546<tel:904%20727-2546>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 18 2012 - 09:18:06 CDT