Re: Authentication Question - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Authentication Question
Date
Msg-id 200312161758.21832.peter_e@gmx.net
Whole thread Raw
In response to Authentication Question  (Jason Hihn <jhihn@paytimepayroll.com>)
List pgsql-general
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@paytimepayroll.com with password 'cow';
> ERROR:  syntax error at or near "@" at character 16

create user "jh@paytimepayroll.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.


pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Authentication Question
Next
From: Michael Fuhr
Date:
Subject: Re: Authentication Question