ERROR: must be superuser to read files et pgcrypto

From: Pierre Crumeyrolle <pierre(dot)crumeyrolle(at)csgroup(dot)eu>
To: pgsql-fr-generale(at)postgresql(dot)org
Subject: ERROR: must be superuser to read files et pgcrypto
Date: 2020-12-10 15:21:06
Message-ID: e838f39c-0157-6d85-d8e5-e578b0c4f13b@c-s.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-fr-generale

bonjour,

je tente d' utiliser les functions pg_crypto  , j’ai une erreur "*ERROR:
must be superuser to read files" **
*

un "GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO ftuser;" ne
change rien**

quelqu'un a t il eu ce type de problème ? Merci

postgres 9.5.16 on linux

psql -h localhost -p 5432 -d FT_DB -U ftuser
Password for user ftuser:
psql (9.5.16)
Type "help" for help.

*FT_DB=> select
ft_decrypt_pwd(password,'3B259A9A610271EC2F07A6E557FBE1DA05770E44') from
ft_user;**
**ERROR:  must be superuser to read files**
**CONTEXT:  PL/pgSQL function ft_decrypt_pwd(bytea,text) line 8 at
assignment**
*

Responses

Browse pgsql-fr-generale by date

  From Date Subject
Next Message Pierre Crumeyrolle 2020-12-10 16:35:22 pgcrypto
Previous Message David TECHER 2020-06-08 14:40:31 Re: Comment déterminer en SQL direct si un foreign server Postgresql est vivant ?