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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux