Обсуждение: regarding user creation

Поиск
Список
Период
Сортировка

regarding user creation

От
Sivakiran Balijepalli
Дата:

Hi

I am new to postgresql

 

I want to create a user account

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

Please guide me..

 

 

Thanks & regards

Siva kiran.B

Re: regarding user creation

От
Andrej
Дата:
On 18 February 2011 00:57, Sivakiran Balijepalli
<Sivakiran.Balijepalli@infor.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