How do you set a specific user's Time Zone without logging in as that user?

Hello,

 

The user's timezone is stored in the SysAdminUnit table, in the TimeZoneId column. However, please note that values in this column are stored not as references to time zones from the directory, but as Time Zone Codes.

You can verify the code in the "Time zones" lookup.

So, you can change this value for any user without logging in with a script in the database:

update "SysAdminUnit" set "TimeZoneId" = 'GMT Standard Time' where "Id" = '***User's Id***'

Thank you for reaching out.

Thanks Pavlo, in the end we added the Timezone field to the System user page (UserPageV2) so that we can change the timezone of users without executing SQL. For others wanting to do the same, we used the following code for the user page replacing schema:

define("UserPageV2", ["UserPageV2Resources"],
	function() {
		return {
			entitySchemaName: "VwSysAdminUnit",
			diff: /**SCHEMA_DIFF*/[
				{
					"operation": "insert",
					"name": "TimeZone",
					"parentName": "Header",
					"propertyName": "items",
					"values": {
						"dataValueType": Terrasoft.DataValueType.ENUM,
						"value": {"bindTo": "TimeZone"},
						"layout": {"column": 13, "row": 2, "colSpan": 8}
					}
				}
			]/**SCHEMA_DIFF*/,
			attributes: {
				/**
				 * Time zone.
				 */
				"TimeZone": {
					dataValueType: Terrasoft.DataValueType.LOOKUP
				}
			}
		};
	}
);