Re: How to find out about user rights - Mailing list pgsql-novice

From Christian Hammers
Subject Re: How to find out about user rights
Date
Msg-id 20121112170554.12c2251c@sys-251.netcologne.de
Whole thread Raw
In response to How to find out about user rights  (Sauer Annegret <sauer@Verwaltung.uni-hohenheim.de>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Restoring data from TABLESPACE files
Next
From: John McLean
Date:
Subject: createdb