How to implement the 'GRANT ALL ON DB1 TO 'USER'@'%' of MYSQL in PostgreSQL - Mailing list pgsql-admin

From 戴松晚
Subject How to implement the 'GRANT ALL ON DB1 TO 'USER'@'%' of MYSQL in PostgreSQL
Date
Msg-id tencent_36961A605AD496835A9F42E3@qq.com
Whole thread Raw
Responses Re: How to implement the 'GRANT ALL ON DB1 TO 'USER'@'%' of MYSQL in PostgreSQL
List pgsql-admin

I have created a user(user1), and with this user I created a db1 and some tables, some functions in it.
Now I want to create another user(user2), and I want the two users can access everything in the database db1,
like GRANT ALL ON DB1 TO 'USER'@'%' ... in MYSQL.

For example:
1, The two users can access all of the exist relations.
2, User2 can access the relations that are created by user1 in the future without any 'grant....'.
3, User1 can access the tables, functions and so on that are created by user2.

Is there any way to do that?
Any insight would be greatly appreciated!

------------------
watson dai

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Re: Possible database corruption - resolved
Next
From: Craig Ringer
Date:
Subject: Re: Possible database corruption