フィードバックを送信
legacy-knowledge-base
公開されました Jun. 30, 2025

CREATE FUNCTIONを実行すると、パーミッション/特権エラーが発生します。

written-by

Tony Ng

How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!

While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.

legacy-article

learn-legacy-article-disclaimer-text

問題

  • CREATE FUNCTION(scalar)文を実行しようとすると、次のエラーが表示されます：
ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Environment

  • LXC-SM

解決策

  • LCP_GCP_DATABASE_FLAG_LOG_BIN_TRUST_FUNCTION_CREATORS 環境変数を 1に設定する。

追加情報

did-this-article-resolve-your-issue
legacy-knowledge-base
did-this-article-resolve-your-issue