Re: How to find out about user rights

Поиск
Список
Период
Сортировка
От Christian Hammers
Тема Re: How to find out about user rights
Дата
Msg-id 20121112170554.12c2251c@sys-251.netcologne.de
обсуждение исходный текст
Ответ на How to find out about user rights  (Sauer Annegret <sauer@Verwaltung.uni-hohenheim.de>)
Список pgsql-novice
Hello

On Thu, 8 Nov 2012 10:59:49 +0000
Sauer Annegret <sauer@Verwaltung.uni-hohenheim.de> wrote:

> Hi all:
>
> I have just started to work with SQL, so maybe the answer to my question is really simple - but I can't find the
answerto it in my books or in Google.  
>
> Is it possible to get a list of all tables within a database for which a certain user has rights? Of course, I could
lookthrough the table list in pgAdmin - but maybe there is something easier?  

I've asked the same question a few month ago and wrote a little VIEW across
some pg_catalog tables as PostgreSQL does not provide something suitable:
  http://archives.postgresql.org/pgsql-novice/2012-07/msg00014.php


> Or - another question - how could you possibly copy the rights of a certain user and assign them to another user?

No idea.

bye,

-christian-



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Restoring data from TABLESPACE files
Следующее
От: John McLean
Дата:
Сообщение: createdb