[rt-users] Reset all ACLs to something sensible

[Philip Kime]

Greetings,
   I have an "organically grown" RT system with a rat's nest of a rights
matrix. I want to clean this out and start again. I have designed and
tested a new set of rights for everyone but I'm wondering as to the best
way of getting this implemented. I have the luxury of a development box
that I can load snapshots of production onto. I can see the following
possibilities:
 
* Dump PROD onto DEV, change things, dump ACL table on DEV and import to
PROD. But this means PROD has to remain static while this is done
otherwise horrible things will happen because of changes to table
indices etc. I can't see PROD not being used while this is done so I
doubt I can do this.
* Manually altering all the PROD ACLs. Will take hours. Horrible but
safe.
* Some sort of API on top of SQL like the rt command line to remove,
replace and re-define rights?
* Manual SQL stuff. Shudder.
 
Any ideas?
 
--
Philip Kime
NOPS Systems Architect
310 401 0407
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060501/2128206f/attachment.htm>