Change owner of a publish set

Brian Steere's Avatar

Brian Steere

22 Jul, 2010 04:44 PM

Is it possible to change the owner of a publish set?
Without giving them access to the admin area?

Or, is it possible to send the publish reports to someone else?
Or to turn of the report?


  1. Support Staff 1 Posted by Tim on 05 Aug, 2010 07:46 PM

    Tim's Avatar

    Hi Brian,

    Apologies for the delayed response on this post.

    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.

    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:

    • As an Administrator, temporarily change the User's password
    • Grant the User Administration access
    • Log in as the User and Edit the Publish Set in question
    • Make a small change to the Publish Set and click Submit
    • Log out as the User
    • 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)

    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.

    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.

    Hope this helps.

  2. 2 Posted by Brian Steere on 05 Aug, 2010 07:50 PM

    Brian Steere's Avatar

    Is there an easy way to change the user through the database?

  3. Support Staff 3 Posted by Tim on 06 Aug, 2010 01:24 PM

    Tim's Avatar

    Typically we don't recommend modifying the database directly, but I think something like this should do the trick:

    update cxml_entitymetadata em, cxml_publishset ps
    set em.lastModifiedBy = '{username}' 
    where ps.metadataId = and = '{publishsetid}';

    You'll need to replace {username} with the user that you want to own the Publish Set. Then, you'll need to replace {publishsetid} with the 25-digit ID of the Publish Set you wish to update.

    Hope this helps!

  4. Tim closed this discussion on 06 Aug, 2010 01:24 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac