Postgres pgcrypto privliledges

postgresql pgcrypto
Doo Dah picture Doo Dah · Sep 14, 2015 · Viewed 7.4k times · Source

I intsalled the pgcrypto extension as the superuser like this:

CREATE EXTENSION pgcrypto;

As the superuser, I tested it, and it works find:

select gen_salt('bf');
           gen_salt
-------------------------------
 $2a$06$CJPcLcOBZnCEl.Z5ChrSbO

But, when logging in as a different user, I get an error as follows:

select gen_salt('bf');
ERROR:  function gen_salt(unknown) does not exist

How do I make the pgcrypto library visible to all users?

Thanks.

Answer

Sami Kuhmonen picture Sami Kuhmonen · Sep 14, 2015

PostgreSQL extensions are per database. If you log in to another database, the extension is not available there. By default the functions are usable by any user.

Related questions

Database column encryption postgres

How to encrypt column in postgres database using pgcrypto addon ? I am using postgres 9.3 and i need to encrypt one of my column , does postgres also support Aes encryption or by any mean i can achieve it ?

Read More
pgp_sym_encrypt and decrypt an entire column in postgresql

I would like to encrypt an area_code column in my postgreSQL database with aes 256 encryption. Here is what happens.. I am able to encrypt it easily but I am not able to decrypt it. Here is the encryption query …

Read More
PostgreSQL query with function gen_random_uuid() not working on Windows

I have the following query for creating a table, CREATE TABLE IF NOT EXISTS company ( id uuid CONSTRAINT companyid PRIMARY KEY DEFAULT gen_random_uuid(), name varchar(128) NOT NULL, db_uri varchar(255) NOT NULL, c_uri varchar(255) NOT NULL, date_…

Read More