tag:help-archives.hannonhill.com,2010-02-09:/discussions/how-do-i/83-change-owner-of-a-publish-setCascade CMS: Discussion 2011-04-07T22:12:02Ztag:help-archives.hannonhill.com,2010-02-09:Comment/23385152010-07-22T16:44:27Z2010-07-22T16:44:27ZChange owner of a publish set<div><p>Is it possible to change the owner of a publish set?<br>
Without giving them access to the admin area?</p>
<p>Or, is it possible to send the publish reports to someone
else?<br>
Or to turn of the report?</p>
<p>Thanks</p></div>Brian Steeretag:help-archives.hannonhill.com,2010-02-09:Comment/23385152010-08-05T19:46:36Z2010-08-05T19:46:36ZChange owner of a publish set<div><p>Hi Brian,</p>
<p>Apologies for the delayed response on this post.<br />
</p>
<p>The owner of a Publish Set is determined by which User modified it most recently. By modified, I mean that a User will need to Edit the Publish Set and make a change to it, then Submit.<br />
</p>
<p>If you would like for a particular User (who does not have access to the Administration area) to be the owner of a Publish Set, I believe you would need to do the following:</p>
<ul>
<li>As an Administrator, temporarily change the User's password</li>
<li>Grant the User Administration access</li>
<li>Log in as the User and Edit the Publish Set in question</li>
<li>Make a small change to the Publish Set and click Submit</li>
<li>Log out as the User</li>
<li>Log in as the normal Admin user again and remove access to the Administration area for the User (also, change the PW again and notify the User)</li>
</ul>
<p>Also, if you need to grant access to the Administration area for Users that normally should not have access, you can always edit the Access rights for any Administration items and take away permissions at a User or Group level.</p>
<p>I'm not aware of any way to change where the publish report is sent nor am I aware of a way to disable the report entirely.</p>
<p>Hope this helps.</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/23385152010-08-05T19:50:42Z2010-08-05T19:50:42ZChange owner of a publish set<div><p>Is there an easy way to change the user through the database?</p></div>Brian Steeretag:help-archives.hannonhill.com,2010-02-09:Comment/23385152010-08-06T13:24:30Z2010-08-06T13:24:30ZChange owner of a publish set<div><p>Typically we don't recommend modifying the database directly, but I think something like this should do the trick:<br />
</p>
<pre><code>update cxml_entitymetadata em, cxml_publishset ps
set em.lastModifiedBy = '{username}'
where ps.metadataId = em.id and ps.id = '{publishsetid}';</code></pre>
<p>You'll need to replace <em>{username}</em> with the user that you want to own the Publish Set. Then, you'll need to replace <em>{publishsetid}</em> with the 25-digit ID of the Publish Set you wish to update.</p>
<p>Hope this helps!</p></div>Tim