Search Postgresql Archives

Re: SV: Foreign tables, user mappings and privilege setup

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

 



Niels Jespersen <NJN@xxxxxx> writes:
> I can create a user mapping for a group (role). This works, but it is not enough to grant the role to the end user (that has inherit defined). The end user must explicitly use "set role" before accessing the foreign table.

Seems right to me.  If the user is a member of two groups, each of which
has a mapping for that server, how could the server choose one?

			regards, tom lane






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux