schema and roles

Поиск
Список
Период
Сортировка
От Alain Roger
Тема schema and roles
Дата
Msg-id 75645bbb0810171045n1a207084kc63530856cf33152@mail.gmail.com
обсуждение исходный текст
Ответы Re: schema and roles  (Josh Williams <joshwilliams@ij.net>)
Список pgsql-general
Hi,

several days ago i wrote a post but i did not get any answer, so i'm asking again just in case of someone hasn't seen it.

in fact i would like to know what are the default schemas allowed or active for a particular role.
usually it's public and $user, but how to get those information ?
i mean if i'm logged with the role "test_user", typing show search_path; will show me all default schemas.
1. is there another place (in som pg_... table) where this information is stored ?
2. if yes how can i get it ?

After that, i know that using alter user test_user .... i can add another schema as default, but how to remove some ?
thanks a lot,

--
Alain
------------------------------------
Windows XP SP3
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008

В списке pgsql-general по дате отправления:

Предыдущее
От: André Volpato
Дата:
Сообщение: Re: VACUUM PANIC: corrupted item pointer
Следующее
От: Tom Lane
Дата:
Сообщение: Re: deferred triggers?