On Apr 11, 7:22 am, Clive Crous <[email protected]> wrote: > Hi all, > > I need to revoke delete and update on a table immediately after > creation. I can't seem to find any "best practice" or even ideas on > how to best accomplish this using migrations. Any suggestions? > (this is a banking transaction table. nobody may ever update or delete > transactions. "updates" happen by inserting corrections with reasons > attached. this is very important for auditing purposes)
Currently there isn't any support for GRANT and REVOKE, though I wouldn't be opposed to adding support for them. GRANT and REVOKE are in SQL-92, but I'm not sure how universal their use is. MySQL and PostgreSQL both support them, but I'm not sure how compatible the syntax is. My gut feeling is they should be adapter level methods if they are added. Anyway, right now your best bet is: DB << 'REVOKE ...' Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
