On Tue, Apr 7, 2020 at 12:09 PM megatronic79 <
[email protected]> wrote:
> hi,
>
> We are trying to enable TOTP for non admins, I have read on the posts that
> we just need to assign the user change own password permission, that's fine
> in the UI, but what is the location in MYSQL for this? I can find all the
> other radio buttons apart from this one, manually going in to the UI for
> over a 1000 users is not really an option but scripting we can but we need
> to know the DB.
>
>
If you're running 1.0.0 or higher, this will be in the
guacamole_user_permission table, and it is the UPDATE permission where
affected_user_id and entity_id are both set to the user in question:
guac=> SELECT * FROM guacamole_user_permission WHERE entity_id=4;
affected_user_id | permission | entity_id
------------------+------------+-----------
4 | READ | 4
4 | UPDATE | 4
-Nick
