Re: [ADMIN] How to implement the 'GRANT ALL ON DB1 TO 'USER'@'%' of MYSQL in PostgreSQL

2013-01-14 Thread Casey Allen Shobe
I'd recommend setting up group roles (roles which cannot login) to grant your various permission sets to, and then add users to the appropriate groups, using permission inheritence. Then any grants/revokes you make in the future to the groups automatically apply to the users. You may wish to divi

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

2013-01-07 Thread 戴松晚
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 acces