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

Поиск
Список
Период
Сортировка
От 戴松晚
Тема How to implement the 'GRANT ALL ON DB1 TO 'USER'@'%' of MYSQL in PostgreSQL
Дата
Msg-id tencent_36961A605AD496835A9F42E3@qq.com
обсуждение исходный текст
Ответы Re: How to implement the 'GRANT ALL ON DB1 TO 'USER'@'%' of MYSQL in PostgreSQL  (Casey Allen Shobe <casey@shobe.info>)
Список 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 по дате отправления:

Предыдущее
От: "Benjamin Krajmalnik"
Дата:
Сообщение: Re: Possible database corruption - resolved
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Possible database corruption