Accessing Extension with out Superuser privilege

From: "Geo P(dot)C(dot)" <pcgeopc(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Accessing Extension with out Superuser privilege
Date: 2015-10-15 13:58:32
Message-ID: CAKtc8vWJnCAuKKur6q0kyg5bnQTBZ5Bt4iPjHu-AnGm8oaikyg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

In PostgreSQL server we created an extension with this command CREATE
EXTENSION "uuid-ossp";

For our drupal site with user "drupal_user" we are trying to access this
but getting an error as "function uuid_generate_v4() does not exist"
When we give privilege for user "drupal_user" as Superuser we are able to
access it.

So please let us know with out giving Superuser privilege how we can give
permission for "drupal_user" to access extension or let me know what
additional role other than Superuser for accessing extension.

Please update us on it.

Thanks & Regards
Ge
*o*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2015-10-15 14:02:14 Re: Accessing Extension with out Superuser privilege
Previous Message Sam Turnbull 2015-10-15 12:10:15 Create objects(table etc) to be stored in specific schema