| From: | Andrej <andrej(dot)groups(at)gmail(dot)com> |
|---|---|
| To: | Sivakiran Balijepalli <Sivakiran(dot)Balijepalli(at)infor(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: regarding user creation |
| Date: | 2011-02-17 16:16:13 |
| Message-ID: | AANLkTi=5jM3xWnhwshyUyoQiw1x1=u2ssKiQ=vzcS-+Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 18 February 2011 00:57, Sivakiran Balijepalli
<Sivakiran(dot)Balijepalli(at)infor(dot)com> wrote:
> So I tried to use “create user” command. but then it is not asking for
> password..User is created.
>
> But when I want to enter the db with that user it is prompting for password.
>
> So how do we create user with password
Just as it says in the fine manual
http://www.postgresql.org/docs/9.0/interactive/sql-createuser.html
CREATE USER user WITH ENCRYPTED PASSWORD 'password';
Cheers,
Andrej
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lille Penguini | 2011-02-17 18:47:51 | even after laboriously following previous post, cannot cast from char to int |
| Previous Message | Thomas Kellerer | 2011-02-17 12:24:52 | Re: (unknown) |