grant usage on schema in PostgreSQL 9.6.3

Asked Jun 12 '17 at 21:42

Active Jun 12 '17 at 21:42

Viewed 498 times

Following the method for PostgresQL 9.1.1 I try to install an extension available to all users:

create schema extensions;
create extension pgcrypto WITH schema extensions;
grant usage on schema extensions to public;
grant execute on all functions in schema extensions to public;

Then I request

select extensions.gen_salt('bf');

under a non-priviledged user, and receive an error message:

ERROR:  schema "extensions" does not exist
LINE 1: select extensions.gen_salt('bf');

Even

create extension pgcrypto schema pg_catalog;

does not help. Is this a bug in PostgreSQL 9.6?

asked Jun 12 '17 at 21:42

Oleg Shalaev

works for me on 9.6.2 (mac) – Neil McGuigan Jun 12 '17 at 23:46
maybe you work on different databases?.. – Vao Tsun Jun 13 '17 at 07:16
Yes, the databases are different. – Oleg Shalaev Jun 14 '17 at 02:08

grant usage on schema in PostgreSQL 9.6.3

0 Answers0