Thanks Nick, That was a rapid response! - ok ive gone ahead and applied this and seems to work, assume this is correct.
REPLACE INTO guacamole_user_permission (`entity_id`, `affected_user_id`, `permission`) SELECT DISTINCT affected_user_id, affected_user_id,'UPDATE' FROM guacamole_user_permission; Cheers Stephen -- Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@guacamole.apache.org For additional commands, e-mail: user-h...@guacamole.apache.org