Re: Limited update ability?
- From: Gints Plivna <gints.plivna@xxxxxxxxx>
- To: Joel.Patterson@xxxxxxxxxxx
- Date: Wed, 18 Apr 2012 17:18:06 +0300
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@xxxxxxxxxxx>
> 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@xxxxxxxxx]
> Sent: Wednesday, April 18, 2012 9:26 AM
> To: Patterson, Joel
> Cc: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxx<mailto:
> Joel.Patterson@xxxxxxxxxxx>> 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>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
