st 22. 5. 2024 v 21:13 odesílatel Ron Johnson
napsal:
> On Wed, May 22, 2024 at 1:58 PM Tom Lane wrote:
>
>> Ron Johnson writes:
>> > That would be a helpful feature for administrators, when there are
>> multiple
>> > schemas in multiple databases, on multiple servers: superusers get ALTER
>> >
st 22. 5. 2024 v 19:54 odesílatel Ron Johnson
napsal:
> On Wed, May 22, 2024 at 12:53 PM David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> On Wed, May 22, 2024, 10:36 Ron Johnson wrote:
>>
>>> This doesn't work, and I've found nothing similar:
>>> ALTER ROLE foo SET SEARCH_PATH = '*
On Wed, May 22, 2024 at 1:58 PM Tom Lane wrote:
> Ron Johnson writes:
> > That would be a helpful feature for administrators, when there are
> multiple
> > schemas in multiple databases, on multiple servers: superusers get ALTER
> > ROLE foo SET SEARCH_PATH = '*'; and they're done with it.
>
>
Ron Johnson writes:
> That would be a helpful feature for administrators, when there are multiple
> schemas in multiple databases, on multiple servers: superusers get ALTER
> ROLE foo SET SEARCH_PATH = '*'; and they're done with it.
... and they're pwned within five minutes by any user with the
On Wed, May 22, 2024 at 12:53 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wed, May 22, 2024, 10:36 Ron Johnson wrote:
>
>> This doesn't work, and I've found nothing similar:
>> ALTER ROLE foo SET SEARCH_PATH = '*';
>>
>
> Correct, you cannot do that.
>
That would be a helpful
On Wed, May 22, 2024, 10:36 Ron Johnson wrote:
> This doesn't work, and I've found nothing similar:
> ALTER ROLE foo SET SEARCH_PATH = '*';
>
Correct, you cannot do that.
David J.
This doesn't work, and I've found nothing similar:
ALTER ROLE foo SET SEARCH_PATH = '*';
Is there a single SQL statement which will generate a search path based
on information_schema.schemata, or do I have to write an anonymous DO
procedure?
SELECT schema_name FROM information_schema.schemata WHE