Re: Revoking delete causes Error 580

Spyros Macris wrote: > > Thanks very much for your reply. > > My ultimate question is: can a DBA have its powers limited - specifically > revoking delete on certain tables -- and the answer is no. Correct. > For example, what I was looking for is the DBA being able to set certain > controls or privileges - like revoke delete - to protect the integrity of the > data so that the DBA would not accidentally delete row(s) of data. Of course this is like restricting root from using the rm command. Someone has to have ultimate responsibility for database changes. > Since I need to maintain my DBA status, I assume the answer to my request is > 1) be careful and 2) backup regularly. Indeed. But why do you need DBA? Perhaps Art & Malcolm have the right solution for you? Keep an account with DBA privilege for 'special' occasions (this is usually informix), and just allow yourself RESOURCE privilege. The effort of logging in as a different user to make database changes may remind you to be careful. ;-) > Mark, do you have any other thoughts? Oh lots, but I've restricted my reply to those on privileges. :-) > Thanks again for taking the time to reply. Not a problem. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+