<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.6944.0">
<TITLE>Deleted Users</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">We've deleted a number of users and have discovered that OpenCMS has not changed the owner of resources previously owned by these users. So we now have a bunch of resources owned by deleted users. This doesn't seem to be much of a problem, but I've found that renaming folders (that are owned by deleted users) now causes errors. The folder gets copied to the new name, but the old folder doesn't get deleted.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">What I want to do is go through all the resources and change the owner for any resources owned by a non-existent user. I can probably put together some SQL to do this directly in the database, but am wondering if there is a simpler option before I try that. Or has anybody else already put together some SQL to do this?</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Many thanks,</FONT>
</P>
<P><SPAN LANG="en-us"><B><I><FONT SIZE=2 FACE="Arial">Brett Beaumont</FONT></I></B></SPAN><B><I><SPAN LANG="en-nz"></SPAN></I><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial"></FONT></SPAN></B><SPAN LANG="en-nz"> </SPAN>
<BR><SPAN LANG="en-us"><I><FONT SIZE=1 FACE="Arial">T</FONT><FONT SIZE=2 FACE="Arial">echnical Consultant </FONT></I></SPAN>
<BR><SPAN LANG="en-us"><I><FONT SIZE=2 FACE="Arial">Sytec Resources Limited</FONT></I></SPAN><I><SPAN LANG="en-nz"><FONT SIZE=2 FACE="Arial"></FONT></SPAN></I><I><SPAN LANG="en-nz"><B></B></SPAN></I><SPAN LANG="en-nz"><B></B><B> </B></SPAN>
</P>
<P><SPAN LANG="en-nz"><I><FONT SIZE=1 FACE="Arial">Phone</FONT></I> <FONT SIZE=1 FACE="Arial">+64 4 473 5805<BR>
</FONT><I><FONT SIZE=1 FACE="Arial">Fax</FONT></I><FONT SIZE=1 FACE="Arial"> +64 4 473 5812</FONT></SPAN>
<BR><SPAN LANG="en-nz"><I><FONT SIZE=1 FACE="Arial">Email</FONT></I><FONT SIZE=1 FACE="Arial"> <U> </U></FONT><U><FONT COLOR="#0000FF" SIZE=1 FACE="Arial"><<A HREF="mailto:brett.beaumont@sytec.com">mailto:brett.beaumont@sytec.com</A>></FONT></U></SPAN>
<BR><SPAN LANG="en-nz"><I><FONT SIZE=1 FACE="Arial">WWW</FONT></I><FONT SIZE=1 FACE="Arial"> <A HREF="http://www.sytec.com">http://www.sytec.com</A></FONT></SPAN>
</P>
<P><SPAN LANG="en-nz"><FONT SIZE=1 FACE="Arial">Important: This electronic mail message and attachments (if any) are confidential and may be legally privileged. If you are not the intended recipient please contact us immediately and destroy this message. You may not legally copy, disclose, disseminate or use the contents in any way. Thank you.</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><B></B></SPAN><SPAN LANG="en-us"><B><I></I></B></SPAN><SPAN LANG="en-us"><B><I></I></B></SPAN></P>
</BODY>
</HTML>