Stephen Frost wrote:
To give 'testuser' the rights of 'testrole' you should do: grant testrole to testuser;
This is because create role, alter role, alter user, etc, use the same set of options (since there's a large overlap) in the syntax, though some things don't make sense for some of those commands.
Ah, that clears things up considerably -- Thanks Stephen! Joe ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster