Jason Hihn wrote:
> 1st problem with using the DB's auth: We want usernames to be email
> addresses, but it chokes on the @ sign:
> # create user jh(at)paytimepayroll(dot)com with password 'cow';
> ERROR: syntax error at or near "@" at character 16
create user "jh(at)paytimepayroll(dot)com" ...;
> 2nd problem with using the DB's auth:
> I need to grant all permissions on all objects in a database to the
> new user. I have get to figure out how this is done easily. I had to
> do it table-by-table!
Use groups.