No subject

In openserdbctl.pgsql it seems that 

"sql_query "$1" "GRANT ALL PRIVILEGES ON DATABASE $1 TO $DBRWUSER;"

will allow the $DBRWUSER to play around with every tables created but it's not the case. Postgresql is not recursive when you grant rights.

We have to do something like this for the $DBRWUSER too..

        GRANT SELECT ON TABLE phonebook, pending, active_sessions, server_monitoring,
        server_monitoring_agg, usr_preferences_types, admin_privileges to $DBROUSER;"

but with more options than just SELECT.

We also need to add rights on the sequences created by the serial types (primary keys).


As it is, openserctl add user1 pass2 user at host  will fail since it cannot select the sequence associated with the id in the subscriber table.





----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1867960&group_id=139143