| Lists: | pgsql-fr-generale |
|---|
| 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 |
| 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**
*
| From: | Michel Payan <michel(dot)payan(at)gmail(dot)com> |
|---|---|
| To: | Pierre Crumeyrolle <pierre(dot)crumeyrolle(at)csgroup(dot)eu> |
| Cc: | pgsql-fr-generale(at)postgresql(dot)org |
| Subject: | Re: ERROR: must be superuser to read files et pgcrypto |
| Date: | 2020-12-10 17:44:05 |
| Message-ID: | CAPFLA-OC8rux20j-PB9e9DpBFdAfup4dqf7_mQgsqjsjwQvH2g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-fr-generale |
Bonsoir,
c'est dans le message d'erreur "*ERROR: must be superuser to read files"*
*Cdt*
Le jeu. 10 déc. 2020 à 16:46, Pierre Crumeyrolle <
pierre(dot)crumeyrolle(at)csgroup(dot)eu> a écrit :
> 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*
>