Re: Can I create multiple schema for one user

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

 



Sunil Vasanta wrote:
> I want application to access multiple scheme based on call context but only one user is created for
> application and application should access different schema using same user privilege and credentials.
> 
> is this possible in Postgres. Plz share u thoughts.
> 
> If possible then how to configure search path.

That shouldn't be a problem.

Just issue
   SET serach_path = <whatever>
after you have determined the context.

Yours,
Laurenz Albe

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[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