How to find out about user rights

From: Sauer Annegret <sauer(at)Verwaltung(dot)uni-hohenheim(dot)de>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: How to find out about user rights
Date: 2012-11-08 10:59:49
Message-ID: EC0415F7C7C0894DAF52842323A2B30E0596F33B@UHVEX01.verwaltung.uni-hohenheim.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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 answer to 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 look through the table list in pgAdmin - but maybe there is something easier?

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

Maybe some background information is helpful. I have two users working with the same topic - one has update, insert, delete-rights for several tables, the other has only select-rights. But there is no complete list. So I either have to find out all the tables for which the first user has update, insert, delete-rights (and then grant those rights to the second user) or I have to copy all the rights of the first user and assign them to the second. But I couldn't find information on how to do this. Can you help me?

Thanks in advance.

Annegret

---
Annegret Sauer
Universität Hohenheim
Kommunikations-, Informations- und Medienzentrum (630)
IT-Dienste | Verwaltungssysteme

Schloss Westhof-Ost | 70599 Stuttgart
Tel.: +49 711 459-23381 | Fax: +49 711 459-24224
Email: sauer(at)verwaltung(dot)uni-hohenheim(dot)de
https://kim.uni-hohenheim.de

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2012-11-08 15:56:29 Re: How to find out about user rights
Previous Message Kevin Grittner 2012-11-02 12:22:00 Re: How to replay to thread