How to find out about user rights
От | Sauer Annegret |
---|---|
Тема | How to find out about user rights |
Дата | |
Msg-id | EC0415F7C7C0894DAF52842323A2B30E0596F33B@UHVEX01.verwaltung.uni-hohenheim.de обсуждение исходный текст |
Ответы |
Re: How to find out about user rights
Re: How to find out about user rights |
Список | 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 toit 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? 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-rightsfor several tables, the other has only select-rights. But there is no complete list. So I either have to findout all the tables for which the first user has update, insert, delete-rights (and then grant those rights to the seconduser) or I have to copy all the rights of the first user and assign them to the second. But I couldn't find informationon 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@verwaltung.uni-hohenheim.de https://kim.uni-hohenheim.de
В списке pgsql-novice по дате отправления: