Accessing Extension with out Superuser privilege

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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
Geo

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux