Re: How to find out about user rights

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-