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
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 |