# You need (at least one of) the SUPER, SYSTEM\_VARIABLES\_ADMIN or SESSION\_VARIABLES\_ADMIN privilege(s) for this operation

**URL:** <https://forum.oxid-esales.com/t/you-need-at-least-one-of-the-super-system-variables-admin-or-session-variables-admin-privilege-s-for-this-operation/98278>\
**Category:** Deutsches Forum\
**Tags:** installation-konfiguration\
**Created:** [February 15, 2022, 11:51am UTC](https://forum.oxid-esales.com/t/you-need-at-least-one-of-the-super-system-variables-admin-or-session-variables-admin-privilege-s-for-this-operation/98278 "2022-02-15T11:51:45Z")\
**Posts on this page:** 1\
**Showing post:** 19

<div class="post-metadata">

**Author:** ![patchwork.de](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/patchwork.de/32/324_2.png) [@patchwork.de](https://forum.oxid-esales.com/u/patchwork.de)\
**Post date:** [February 18, 2022, 10:06am UTC](https://forum.oxid-esales.com/t/you-need-at-least-one-of-the-super-system-variables-admin-or-session-variables-admin-privilege-s-for-this-operation/98278/19 "2022-02-18T10:06:41Z")

</div>

> [@Oliver\_He](#):
>
> … wo genau die von den Scripten in migration/data/ verursachten probleme herkommen,…

→ The [`ENCODE()`](https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html#function_encode) and [`DECODE()`](https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html#function_decode) functions are deprecated in MySQL 5.7, and should no longer be used. Expect them to be removed in a future MySQL release.  
[https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html](https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html)

---

_[View the full topic](https://forum.oxid-esales.com/t/you-need-at-least-one-of-the-super-system-variables-admin-or-session-variables-admin-privilege-s-for-this-operation/98278)._
