How to implement the 'GRANT ALL ON DB1 TO 'USER'@'%' of MYSQL in PostgreSQL

From: 戴松晚 <151359779(at)qq(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: How to implement the 'GRANT ALL ON DB1 TO 'USER'@'%' of MYSQL in PostgreSQL
Date: 2013-01-08 02:15:30
Message-ID: tencent_36961A605AD496835A9F42E3@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 I want to create another user(user2), and I want the two users can access everything in the database db1,<br>like GRANT ALL 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: Arial Narrow; 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>

Attachment Content-Type Size
unknown_filename text/html 852 bytes

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Craig Ringer 2013-01-08 02:23:56 Re: Possible database corruption
Previous Message Benjamin Krajmalnik 2013-01-08 00:04:54 Re: Possible database corruption - resolved