Re: How to find out about user rights

Sauer Annegret <sauer(at)Verwaltung(dot)uni-hohenheim(dot)de> writes:
> 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?

You could look into the information_schema views, or you could write a
query using the has_table_privilege() function.

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

There's no mechanism for doing that. Usually the recommended solution
for "sharing" rights is to assign the rights to a role created for the
purpose, and then to grant use of that role to the individual users.
However this approach requires a bit of foresight ...

regards, tom lane