Cursors out of a transaction

Started by David Prieto Carrellanover 27 years ago2 messagesgeneral
Jump to latest
#1David Prieto Carrellan
davidp@arrakis.es

Hi.

Why can't I use a cursor out of a transaction block? I really need to
do it, since I'm working with a great amount of data, and can't do
simply a 'select' and get all the results. And this is an interactive
process, which may be interrupted at any time, and I want all the
changes to be kept.

--
Greetings.
David Prieto.
mailto:davidp@arrakis.es

#2Javier E Polo
jpolo@luna.uniandes.edu.co
In reply to: David Prieto Carrellan (#1)
revoke!!!

I'm trying to revoke some permisios to an user in a table, but It isn't working.

The commands said me that it changed the rights but the user still can do the
operation.

Which conditions do I need to make revoke works?