-- Create roles needed in pmm postgresql-instance
-- lpsql pmm -U postgres -f thisfile (but with appropriate passwords)
CREATE ROLE "pmm.owner" LOGIN;
CREATE ROLE "pmm.dataman" LOGIN;
CREATE ROLE "pmm.read";
CREATE ROLE "pmm.app" LOGIN PASSWORD '............';
GRANT "pmm.dataman" TO "pmm.owner";
GRANT "pmm.read" TO "pmm.dataman";
GRANT "pmm.read" TO "pmm.app";