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  (Casey Allen Shobe <casey@shobe.info>)
List pgsql-admin
<br />I have created a user(user1), and with this user I created a db1 and some tables, some functions in it.<br />Now
Iwant to create another user(user2), and I want the two users can access everything in the database db1,<br />like
GRANTALL ON DB1 TO 'USER'@'%' ... in MYSQL.<br /><br />For example:<br />1, The two users can access all of the exist
relations.<br/>2, User2 can access the relations that are created by user1 in the future without any 'grant....'.<br
/>3,User1 can access the tables, functions and so on that are created by user2.<br /><br />Is there any way to do
that?<br/>Any insight would be greatly appreciated!<br /><br /><div><div style="color: rgb(144, 144, 144); font-family:
ArialNarrow; font-size: 12px;">------------------</div><div style="font-size: 14px; font-family: Verdana; color: rgb(0,
0,0);">watson dai<br /></div></div><div><br /></div> 

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