| From: | Christian Hammers <ch(at)lathspell(dot)de> |
|---|---|
| To: | Sauer Annegret <sauer(at)Verwaltung(dot)uni-hohenheim(dot)de> |
| Cc: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: How to find out about user rights |
| Date: | 2012-11-12 16:05:54 |
| Message-ID: | 20121112170554.12c2251c@sys-251.netcologne.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hello
On Thu, 8 Nov 2012 10:59:49 +0000
Sauer Annegret <sauer(at)Verwaltung(dot)uni-hohenheim(dot)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 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?
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-
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John McLean | 2012-11-13 17:00:49 | createdb |
| Previous Message | Tom Lane | 2012-11-11 16:39:27 | Re: Restoring data from TABLESPACE files |