[rt-users] Reset all ACLs to something sensible

Drew Barnes barnesaw at ucrwcu.rwc.uc.edu
Tue May 2 08:40:16 EDT 2006


You could install RTx::RightsMatrix and use edit mode to reset the 
rights so you can then set up the rights you want.

Philip Kime wrote:
> 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
>  
> ------------------------------------------------------------------------
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>
>
> We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html

-- 
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati




More information about the rt-users mailing list